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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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