Horton
Menu

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

Thomas Lockhart <lockhart@alumni.caltech.edu>

View thread
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: lockhart@fourpalms.org, "cstraka@incontactnow.com" <cstraka@incontactnow.com>, "'pgsql-bugs@postgresql.org'" <pgsql-bugs@postgresql.org>
Date: 2001-04-06T15:12:30Z
Lists: 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