Hi all,
here is a little test case for a problem we run into in our
developpement
Is it a bug or a setting problem ?
try
select (current_timestamp),(current_timestamp - interval '1008 hours');
report this value in age()
select age('2009-06-23 18:36:05.064066+02' ,'"2009-05-12 18:36:05.064066
+02"');
then use all in this :
SELECT EXTRACT(EPOCH FROM TIMESTAMP '2009-06-23 18:36:05.064066+02') -
EXTRACT(EPOCH FROM TIMESTAMP '"2009-05-12 18:36:05.064066+02"'),
EXTRACT(EPOCH FROM interval '1 mon 11 days');
Can I workaround this ?
Regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
