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-15 16:56:25
Message-ID: 2F9ADE33-9F9B-4302-ACC3-3E6FD43AE35A@gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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: Alvaro HerreraDate: 2011-12-15 18:01:52
Subject: Re: BUG #6337: Startup Script
Previous:From: nelson-m-marquesDate: 2011-12-15 16:27:59
Subject: BUG #6341: Packaging - virtual provides "postgres" without version

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