Postgres Pro
Downloads
Home   >   mailing lists

Re: Epoch extraction - Mailing list pgsql-sql

From Tom Lane
Subject Re: Epoch extraction
Date
Msg-id 12131.1046538434@sss.pgh.pa.us
Whole thread Raw
In response to Epoch extraction  ("Denis Arh" <denis@exonium.net>)
List pgsql-sql
Tree view 
"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

pgsql-sql by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: Executing SQL commands via triggers without the use of procedures
Next
From: Rod Taylor
Date:
Subject: Re: Denormalizing during select