Re: timestamp_part() bug?

From: domingo(at)dad-it(dot)com (Domingo Alvarez Duarte)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: timestamp_part() bug?
Date: 2002-03-05 21:22:25
Message-ID: 70a76315.0203051322.4aa84369@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 ?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Padgett 2002-03-05 21:42:25 Re: Postgresql backend to perform vacuum automatically
Previous Message Dann Corbit 2002-03-05 21:16:28 Re: Postgresql backend to perform vacuum automatically