| From: | "Glen and Rosanne Eustace" <agree(at)godzone(dot)net(dot)nz> |
|---|---|
| To: | "Christopher Sawtell" <csawtell(at)xtra(dot)co(dot)nz>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Re: Problem with Dates |
| Date: | 2001-01-26 17:44:26 |
| Message-ID: | 012701c087bf$a2ae2940$0101a8c0@godzone.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> Could one of you try it in 7.1 (beta3 or later)? We've changed some
> details of the way daylight-savings transitions are handled in
> date-to-timestamp conversions, so I think this might be fixed now.
> It's worth checking anyway.
I would prefer not to upgrade right at the moment, as my development
system is in the middle of a migration exercise ( hence the discovery of
this bug ).
If some one else is running 7.1 already and can just change their
timezone to New Zealand DT and report the results it would be great.
> Also, what do you get from '31/12/2000'::date::timestamp?
template1=# select '31/12/2000'::date::timestamp
template1-# ;
?column?
------------------------
2001-01-01 00:00:00+13
(1 row)
template1=#
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-26 18:00:17 | Re: Re: Problem with Dates |
| Previous Message | Josh Berkus | 2001-01-26 17:27:50 | Request for change in PL/PGSQL function handler |