Re: Time is off in PG server

From: "Jay A(dot) Kreibich" <jak(at)uiuc(dot)edu>
To: Ericson Smith <eric(at)did-it(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Time is off in PG server
Date: 2004-08-26 14:38:18
Message-ID: 20040826143818.GA7800@uiuc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)uiuc(dot)edu | Campus IT & Edu. Svcs.
<http://www.uiuc.edu/~jak> | University of Illinois at U/C

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-08-26 14:51:21 Re: Odd double queries continues
Previous Message Ericson Smith 2004-08-26 13:47:26 Time is off in PG server