Ericson Smith <eric@did-it.com> writes:
> 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)
Looks exactly right to me. 1093496400 corresponds to 1AM EDT, or
midnight EST, and after all you do have the timezone set to EST.
Possibly you want the zone set to EST5EDT instead.
regards, tom lane