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

Re: BUG #6340: to_timestamp() miscalculates

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <hfuxelius(at)gmail(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6340: to_timestamp() miscalculates
Date: 2011-12-15 16:20:15
Message-ID: 4EE9C9DF0200002500043D02@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: nelson-m-marquesDate: 2011-12-15 16:27:59
Subject: BUG #6341: Packaging - virtual provides "postgres" without version
Previous:From: Tom LaneDate: 2011-12-15 16:16:35
Subject: Re: BUG #6340: to_timestamp() miscalculates

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