Thanx a lot for your promt respons :) You are absolutely right, its the day=
light 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:
>=20
>> test to run: select to_timestamp('2011,03,27,02,11,11',
>> 'YYYY,MM,DD,HH24,MI,SS')
>>=20
>> and the run: select to_timestamp('2011,03,27,03,11,11',
>> 'YYYY,MM,DD,HH24,MI,SS')
>>=20
>> It miscalculates 02 hour to 03 hour by some reason
>=20
> 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?
>=20
> -Kevin