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

Поиск
Список
Период
Сортировка
От Username_PalmTreesNSand
Тема BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'
Дата
Msg-id 200803101320.m2ADK9dV052431@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: setseed accepts bad seeds
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCH] Don't bail with legitimate -N/-B options