BUG #1332: wrong results from age function

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1332: wrong results from age function
Date: 2004-11-29 11:37:50
Message-ID: 20041129113750.3543A7385D6@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1332
Logged by: Robert Grabowski

Email address: grabba(at)env(dot)pl

PostgreSQL version: 7.4.6

Operating system: Linux

Description: wrong results from age function

Details:

select age('2004-02-01'::date, '2004-01-01'::date);
age
-------
1 mon
(1 row)

select age('2004-03-01'::date, '2004-02-01'::date);
age
---------
29 days
(1 row)

I think, it should be "1 mon".

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kouber Saparev 2004-11-29 15:33:32 Ambiguous behaviour of age(timestamp)
Previous Message PostgreSQL Bugs List 2004-11-29 11:26:06 BUG #1331: after update: vacuum blocks parallel to select