Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group