From: | "J(dot)Simon Goodall" <simon(at)EstanciaViamonte(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1637: age() function is giving different results |
Date: | 2005-04-28 19:47:25 |
Message-ID: | 20050428194725.0EA00F0D21@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1637
Logged by: J.Simon Goodall
Email address: simon(at)EstanciaViamonte(dot)com
PostgreSQL version: 7.4.2
Operating system: Linux
Description: age() function is giving different results
Details:
With the same query the age function is giving me two results, one as it
should be (34 years) and the other one is off by 1 hour, the query is a
single one so the results I asume should be the same.
I have tried finding the age(,) function in the source but had no luck.
Would appreciate some help, thx.
Simon.
Z SQL Method Z SQL Method at /StockMan/select_birthdays
Famname Firstname Birth date Age
Surname1 Name1 1971-05-05 34 years
Surname2 Name2 1964-05-05 40 years 11 mons 30 days 23:00:00
SQL used:
SELECT famname, firstname, birth_date, age( DATE '2005-05-05'::date,
birth_date::date )
FROM addresses
WHERE
EXTRACT ( day FROM timestamp '2005-05-05') = EXTRACT ( day FROM
birth_date)
AND
EXTRACT ( month FROM timestamp '2005-05-05') = EXTRACT ( month FROM
birth_date);
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-04-28 22:26:05 | Re: BUG #1637: age() function is giving different results |
Previous Message | Mike G. | 2005-04-28 19:13:15 | Re: BUG #1635: Failed to create process for initdb |