Oscar Estevez Lopez <[EMAIL PROTECTED]> writes:
> d : 1059744638
> d::timestamp : 1059737438
> ??
This is fixed as of PG 7.3.4 ...
2003-02-27 16:37 tgl
* src/backend/utils/adt/timestamp.c (REL7_3_STABLE): Change
EXTRACT(EPOCH FROM timestamp) so that a timestamp without time zone
is assumed to be in local time, not GMT. This improves consistency
with other operations, which all assume local timezone when it
matters. Per bug #897.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])