date function 'age' problem

From: "Konrad Gdowski" <konrad(at)spox(dot)org>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: date function 'age' problem
Date: 2002-03-31 22:22:48
Message-ID: NEBBKCCMCKJFAGKKEMNCEEAHCGAA.konrad@spox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

hello

i've got the following error:

here is the output:

#######################################################################
osk=> select age('2001-03-29','2001-03-01');
age
---------------
27 days 23:00
(1 row)

osk=> select age('2002-03-29','2002-03-01');
age
-------
1 mon
(1 row)

osk=> select version();
version
---------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.95.4
(1 row)

osk=>

#####################################################################

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'.
thanks for any solutions to this problem.

best regards
konrad gdowski

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jie Liang 2002-04-01 20:11:12 pg_dump bug
Previous Message Ryan Grange 2002-03-31 17:05:57 PGAccess and apostrophes...