Skip site navigation (1) Skip section navigation (2)

BUG #4878: function age() give a wrong interval

From: "" <pamelant(at)companeo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4878: function age() give a wrong interval
Date: 2009-06-25 09:28:50
Message-ID: 200906250928.n5P9SoZg015973@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Frank HeikensDate: 2009-06-25 09:40:51
Subject: Re: BUG #4878: function age() give a wrong interval
Previous:From: Craig RingerDate: 2009-06-24 23:38:05
Subject: Re: psql: FATAL: the database system is in recovery mode

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group