Re: Time is off in PG server - Mailing list pgsql-admin

From Jay A. Kreibich
Subject Re: Time is off in PG server
Date
Msg-id 20040826143818.GA7800@uiuc.edu
Whole thread Raw
In response to Time is off in PG server  (Ericson Smith <eric@did-it.com>)
List pgsql-admin
On Thu, Aug 26, 2004 at 09:47:26AM -0400, Ericson Smith scratched on the wall:
> Hi,
>
> When using date oriented functions on Postgresql, the time is an hour
> off, or in certain times, one hour ahead.
>
> System Timezone: EST
                   ^^^
> System Time (date command): Thu Aug 26 09:44:28 EDT 2004
                                                  ^^^
> SELECT now(); : 2004-08-26 08:44:31.307343-05
> SELECT date_part('epoch', '2004-08-26'::timestamp) ; : 1093496400 (1am
> on that day -- should be 12pm)
>
> Any suggestions?

  Work in the same timezone.  EST and EDT are not the same.

   -j

--
                     Jay A. Kreibich | Integration & Software Eng.
                        jak@uiuc.edu | Campus IT & Edu. Svcs.
          <http://www.uiuc.edu/~jak> | University of Illinois at U/C

pgsql-admin by date:

Previous
From: Ericson Smith
Date:
Subject: Time is off in PG server
Next
From: Tom Lane
Date:
Subject: Re: Odd double queries continues