Re: BUG #14182: Wrong time stamp exactly at 1996 hour 3 - Mailing list pgsql-bugs

On 6/8/2016 1:37 PM, olmozavala@gmail.com wrote:
> If you create a table with just id and mydate (timestamp without zone) and
> then you execute:
>
> INSERT INTO test (fecha) VALUES
> (to_timestamp('07/04/1996/2','DD/MM/YY/HH24'))
> INSERT INTO test (fecha) VALUES
> (to_timestamp('07/04/1996/3','DD/MM/YY/HH24'))
>
> It should give you two different hours, but it will give you the same hour.
> I was filling a very large database and this problem seems to appear only at
> this specific date and time.

that date/time is exactly when DST began that year in the USA... The
function to_timestamp returns a timestamptz (timestamp with time zone).

--
john r pierce, recycling bits in santa cruz