On 2005-07-22, Bruce Momjian wrote:
>>
>> select (CURRENT_DATE + '05:00'::time)::timestamp
>>at time zone 'Canada/Pacific';
>> timezone
>>
>> 2005-07-19 22:00:00+00
>> (1 row)
>>
> What is happening here is that 2005-07-20 05:00:00 is being cast back
Jeff Trout wrote:
>
> On Jul 21, 2005, at 11:57 PM, Bruce Momjian wrote:
>
> >works fine now. It will also obey whatever DST rules were in
> effect at
> >just that date, which the previous implementation did not.
>
> Speaking of that, would the nearly passed US bill to extend dayligh
On Jul 21, 2005, at 11:57 PM, Bruce Momjian wrote:
>works fine now. It will also obey whatever DST rules were in
effect at
>just that date, which the previous implementation did not.
Speaking of that, would the nearly passed US bill to extend daylight
savings screw up our timezone
Kevin McArthur wrote:
> There appear to be several bugs in the at time zone patch recently applied.
>
>
> show timezone;
> TimeZone
> --
> UTC
> (1 row)
>
> select now();
> now
> ---
> 2005-07-20 23:38:57.981128+00
> (1 row)
>
My guess is that is this commit that is causing the problem:
revision 1.110
date: 2005/06/15 00:34:08; author: momjian; state: Exp; lines: +48
-40
This patch makes it possible to use the full set of timezones when doing
"AT TIME ZONE", and not just the shorlist
There appear to be several bugs in the at time zone
patch recently applied.
show timezone; TimeZone
-- UTC(1 row)
select
now();
now
--- 2005-07-20 23:38:57.981128+00(1
row)
***
WORKS ***
select CURRENT_DATE + '05:00
