The following bug has been logged online:

Bug reference:      4878
Logged by:          
Email address:      pamel...@companeo.com
PostgreSQL version: 8.2.4, 8.3.6
Operating system:   linux
Description:        function age() give a wrong interval
Details: 

age() report a wrong interval in some case

example

intervall between the 2 dates is 1008 hours

select age('2009-06-23 18:36:05.064066+02' ,'"2009-05-12 18:36:05.064066
+02"') > interval '1000 hours';

result is false instead of true.
There is a 24 hours error in the age() results

regards

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to