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])

Reply via email to