Обсуждение: BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'
BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'
От
"Username_PalmTreesNSand"
Дата:
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