Thread: Epoch extraction

Epoch extraction

From

"Denis Arh"

Date:

01 March 2003, 12:57:20

When i extract epoch from field (timestamp(0) without time zone) I get the time that is set in that field plus one hour...

Is that a bug or am I just missing something....

Regards,

Denis Arh

Re: Epoch extraction

From

Tom Lane

Date:

01 March 2003, 15:07:17

"Denis Arh" <denis@exonium.net> writes:
> When i extract epoch from field (timestamp(0) without time zone) I get
> the time that is set in that field plus one hour...

I suppose you live in a GMT+1 time zone?

> Is that a bug or am I just missing something....

See thread at
http://archives.postgresql.org/pgsql-bugs/2003-02/msg00069.php        regards, tom lane