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