Postgres Pro
Downloads
Home   >   mailing lists

Re: DISTINCT ON troubles - Mailing list pgsql-sql

From Brian Knox
Subject Re: DISTINCT ON troubles
Date
Msg-id 40352541.8040507@aol.net
Whole thread Raw
In response to Re: DISTINCT ON troubles  ("Jeremy Smith" <jer@highboard.com>)
Responses Re: DISTINCT ON troubles  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-sql
Tree view 
( sorry if this is a repeat, my mail server is being wonky today )

I'm looking for a way, within SQL, given a starting date and an ending 
date, to get back the number of months between the start and end date. 
If I "SELECT end_date - start_date", I get back an interval in days; I 
need months.

Thanks for any suggestions,
Brian

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Compiling pl/pgsql functions
Next
From: Jan Wieck
Date:
Subject: Re: Compiling pl/pgsql functions