Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: How to do?
Next
From: Karsten Hilbert
Date:
Subject: Re: PC color icon data?