Обсуждение: Epoch extraction

Поиск
Список
Период
Сортировка

Epoch extraction

От
"Denis Arh"
Дата:
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

От
Tom Lane
Дата:
"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