"Username_PalmTreesNSand" <webdata9(at)comcast(dot)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
In response to
pgsql-bugs by date
|Next:||From: Shawn Chasse||Date: 2008-03-10 14:53:34|
|Subject: Rulese Bug: Instead of reporting incorrect insert count.|
|Previous:||From: Bruce Momjian||Date: 2008-03-10 14:05:46|
|Subject: Re: [PATCH] Don't bail with legitimate -N/-B options|