The following bug has been logged online:

Bug reference: 4022
Logged by: Username_PalmTreesNSand
Email address: webdata9@comcast.net
PostgreSQL version: 8.3
Operating system: Windows Vista
Description: DST Time Zone Bug related to: select now() at time
zone 'EST'
Details:

I have recently noticed a problem since the Daylight savings time change
(past 1-2 days).
The following query returns the time from an hour ago (I'm in EST, but I
need to be able to handle other time zones):
select now() at time zone 'EST'
or select now() at time zone 'CST'

This query returns the correct time for EST:
select now()

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

"Username_PalmTreesNSand" <webdata9@comcast.net> writes:
> I have recently noticed a problem since the Daylight savings time change
> (past 1-2 days).
> The following query returns the time from an hour ago (I'm in EST, but I
> need to be able to handle other time zones):
> select now() at time zone 'EST'
> or select now() at time zone 'CST'

> This query returns the correct time for EST:
> select now()

I see no bug here. We're in daylight saving time now, so the zone is
EDT not EST. IOW, if it's currently 10:10 EDT, it is also a true
statement that it's 9:10 EST.

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs