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: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
> test to run: select to_timestamp('2011,03,27,02,11,11',
> and the run: select to_timestamp('2011,03,27,03,11,11',
> 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


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-2017 The PostgreSQL Global Development Group