| 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
| 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 |