Skip site navigation (1) Skip section navigation (2)

BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'

From: "Username_PalmTreesNSand" <webdata9(at)comcast(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'
Date: 2008-03-10 13:20:09
Message-ID: 200803101320.m2ADK9dV052431@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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
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()

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2008-03-10 14:05:46
Subject: Re: [PATCH] Don't bail with legitimate -N/-B options
Previous:From: Tom LaneDate: 2008-03-10 12:39:53
Subject: Re: setseed accepts bad seeds

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group