Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Lockhart
Subject Re: Re: to_char miscalculation on April Fool's Day - the start of daylight savings
Date
Msg-id 3ACDDCDE.6593CD01@alumni.caltech.edu
Whole thread Raw
In response to to_char miscalculation on April Fool's Day - the start of daylight savings  (Chris Straka <cstraka@incontactnow.com>)
List pgsql-bugs
Tree view 
> > 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: to_char miscalculation on April Fool's Day - the start of daylight savings
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: inet function return untestable texts