Postgres Pro
Downloads
Home   >   mailing lists

Re: Date / interval question - Mailing list pgsql-sql

From Gnugeek
Subject Re: Date / interval question
Date
Msg-id 403524D6.5060706@comcast.net
Whole thread Raw
In response to Re: DISTINCT ON troubles  ("Jeremy Smith" <jer@highboard.com>)
List pgsql-sql
Tree view 

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: fasteddie_g@yahoo.com (FastEddie)
Date:
Subject: SQL / Join Help
Next
From: Rod Taylor
Date:
Subject: Re: Compiling pl/pgsql functions