> osk=> select age('2001-03-29','2001-03-01');
> ---------------
> 27 days 23:00
> osk=> select age('2002-03-29','2002-03-01');
> -------
> 1 mon
> osk=> select version();
> PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.95.4
...
> look at the difference betwen results of execution function 'age' for the
> same time interval in year 2001 and 2002. why there is '1 mon' when it
> should be '27 days'.
You may be calculating an interval across daylight savings time
boundaries, which may have been done without accounting for time zones
in the version you are running. I'm not able to reproduce the problem on
my 7.2 installation:
thomas=# set time zone 'pst8pdt';
SET VARIABLE
thomas=# select age('2001-03-29','2001-03-01');
---------
28 days
thomas=# select age('2002-03-29','2002-03-01');
---------
28 days
thomas=# select version();
-----------------------------------------------------------
PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.96
May be time to upgrade...
- Thomas