Re: BUG #6340: to_timestamp() miscalculates

Thanx a lot for your promt respons :) You are absolutely right, its the daylight saving that date and hour, I had it as an key in my GPS data and was very confused!!!

Again - Thanx
/Hans-Henrik
On Dec 15, 2011, at 5:20 PM, Kevin Grittner wrote:

> wrote:
>
>> test to run: select to_timestamp('2011,03,27,02,11,11',
>> 'YYYY,MM,DD,HH24,MI,SS')
>>
>> and the run: select to_timestamp('2011,03,27,03,11,11',
>> 'YYYY,MM,DD,HH24,MI,SS')
>>
>> It miscalculates 02 hour to 03 hour by some reason
>
> I don't know what time zone you're in, or whether daylight saving
> time kicks in on that date. *Is* there a 02:11:11 on that date, or
> is that when time "springs forward" by an hour in the spring for your
> locale?
>
> -Kevin