Re: Re: to_char miscalculation on April Fool's Day - the start of daylight savings

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: Re: to_char miscalculation on April Fool's Day - the start of daylight savings
Дата
Msg-id 3ACDDCDE.6593CD01@alumni.caltech.edu
обсуждение исходный текст
Ответ на to_char miscalculation on April Fool's Day - the start of daylight savings  (Chris Straka <cstraka@incontactnow.com>)
Список pgsql-bugs
Дерево обсуждения 
> > Have you tried to use "date 'today'" rather than "now()"? As in
> >   select to_char(date 'today' - 1, 'YYYY-MM-DD');
> That will still fail in 7.0.* when the selected date is a DST transition
> day, because of the bug in date-to-timestamp conversion (which will
> happen at the input to to_char()).

Ah, right. I had tested in the GMT time zone, which cures all ills :(

                    - Thomas

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: to_char miscalculation on April Fool's Day - the start of daylight savings
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: inet function return untestable texts