Re: extract and time zones - Mailing list pgsql-general

From Oscar Estevez Lopez
Subject Re: extract and time zones
Date
Msg-id 20030811171130.3e079e8e.oestevez@prisacom.com
Whole thread Raw
In response to Re: extract and time zones  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.   
============================================================================

pgsql-general by date:

Previous
From: Oscar Estevez Lopez
Date:
Subject: Re: extract and time zones
Next
From: Franco Bruno Borghesi
Date:
Subject: Re: public key functions for postgresql ?