Postgres Pro
Downloads
Home   >   mailing lists

BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST' - Mailing list pgsql-bugs

From Username_PalmTreesNSand
Subject BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'
Date
Msg-id 200803101320.m2ADK9dV052431@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'
List pgsql-bugs
Tree view 
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()

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: setseed accepts bad seeds
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCH] Don't bail with legitimate -N/-B options