The following bug has been logged online:
Bug reference: 4878
Logged by:
Email address: pamelant(at)companeo(dot)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