Skip site navigation (1) Skip section navigation (2)

Re: BUG #6340: to_timestamp() miscalculates

From: Hans-Henrik Fuxelius <hfuxelius(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6340: to_timestamp() miscalculates
Date: 2011-12-16 08:43:17
Message-ID: CANZ-B9w3G1kFXJQGDBkPe-nRmMkzKCryDqAK7WMuUQF6vtCTmg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
It seems not possible to suppress to_timestamp from doing daylight
saving conversion, I have GPS timeseries that looks perfect in the
'timestamp without time zone' save one value that wreck the whole time
serie, does that mean that time series cant be stored in time stamps?

/Hans-Henrik

On Thu, Dec 15, 2011 at 5:56 PM, Hans-Henrik Fuxelius
<hfuxelius(at)gmail(dot)com> wrote:
> 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
>

In response to

Responses

pgsql-bugs by date

Next:From: Martin PittDate: 2011-12-16 09:36:46
Subject: TAS patch for building on armel/armhf thumb
Previous:From: Craig RingerDate: 2011-12-16 08:24:36
Subject: Re: BUG #6342: libpq blocks forever in "poll" function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group