Re: BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'

"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