Horton

Re: timestamp_part() bug?

Domingo Alvarez Duarte <domingo@dad-it.com>

View thread View on postgr.es
From: domingo@dad-it.com (Domingo Alvarez Duarte)
To: pgsql-hackers@postgresql.org
Date: 2002-03-05T21:22:25Z
Lists: pgsql-hackers 
There is a problem with epoch as well that was not in the 7.1.3


7.1.3# select extract(epoch from '00:00:34'::time), now();
7.1.3# 34  2002-03-05 22:13:16 +01

7.2# select extract(epoch from '00:00:34'::time), now();
7.2# 3634  2002-03-05 22:13:16 +01

7.2# select extract(epoch from '00:00:34'::time without time zone), now();
7.2# 3634  2002-03-05 22:13:16 +01

Is that a bug or I didn't understand the new date/time types ?