Re: Date / interval question

am Thu, dem 10.04.2008, um 21:26:14 -0600 mailte kevin kempter folgendes:
> I can get the number of days since the start of the fiscal year like
> this:
>
> # select date '01/01/2007' - date '09/01/2006' as interval;
> interval
> ----------
> 122
> (1 row)
>
> However I'm stumped [er how to get the number of months from
> 09/01/2007 thru 01/01/2007
>
> Thoughts ?

test=*# select age(date '01/01/2007',date '09/01/2006');
age
--------
4 mons

For a longer interval:

test=*# select age(date '01/01/2007',date '09/05/2005');
age
-----------------------
1 year 3 mons 26 days
(1 row)

test=*# select extract('month' from age(date '01/01/2007',date '09/05/2005'));
date_part
-----------
3
(1 row)

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net