Обсуждение: BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'

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

"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