Re: extract and time zones

El Fri, 01 Aug 2003 10:55:49 -0400
Tom Lane <tgl@sss.pgh.pa.us> escribio:

thanks :)

> Oscar Estevez Lopez <oestevez@prisacom.com> 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 majordomo@postgresql.org)


--

________________________________________________________
One ping to rule them all, one ping to find them,
one ping to bring them all and in the darkness bind them.
(Lord of the windows)


============================================================================
This e-mail message and any attached files are intended SOLELY for the addressee/s identified herein. It may contain
CONFIDENTIALand/or LEGALLY PRIVILEGED  information and may not necessarily represent the opinion of this company. If
youreceive this message in ERROR, please immediately notify the sender and DELETE it since you ARE NOT AUTHORIZED  to
use,disclose, distribute, print or copy all or part of the contained information. Thank you.   
============================================================================