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

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: lockhart(at)fourpalms(dot)org, "cstraka(at)incontactnow(dot)com" <cstraka(at)incontactnow(dot)com>, "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Re: to_char miscalculation on April Fool's Day - the start of daylight savings
Date: 2001-04-06 15:12:30
Message-ID: 3ACDDCDE.6593CD01@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-04-06 15:40:33 inet function return untestable texts
Previous Message Tom Lane 2001-04-06 14:22:45 Re: Re: to_char miscalculation on April Fool's Day - the start of daylight savings