The following bug has been logged online:
Bug reference: 4022
Logged by: Username_PalmTreesNSand
Email address: webdata9(at)comcast(dot)net
PostgreSQL version: 8.3
Operating system: Windows Vista
Description: DST Time Zone Bug related to: select now() at time
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:
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2008-03-10 14:05:46|
|Subject: Re: [PATCH] Don't bail with legitimate -N/-B options|
|Previous:||From: Tom Lane||Date: 2008-03-10 12:39:53|
|Subject: Re: setseed accepts bad seeds |