> Should the query
> from cast('2012-01-01 14:30:1' as
> timestamp) -
> cast('1970-01-01 0:0:0' as
> timestamp))) -
> from (cast('2012-01-01 14:30:1' as
> return 0 instead of 3600?
Well, right now it's operating as designed, because extract(epoch,
timestamp without timezone) tries to rotate the timestamp from local
time to GMT so that "epoch 0" corresponds to midnight GMT 1970-01-01.
(I presume that you are in a GMT+1 timezone.)
Changing that behavior is one of the possible solutions to the problem
being discussed over here:
but I don't believe we have any consensus yet about whether that
would be a good idea.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2012-02-01 16:04:15|
|Subject: Re: BUG #6425: Bus error in slot_deform_tuple |
|Previous:||From: Robert Haas||Date: 2012-02-01 15:38:40|
|Subject: Re: BUG #6200: standby bad memory allocations on SELECT|