BUG #14182: Wrong time stamp exactly at 1996 hour 3

From: olmozavala(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14182: Wrong time stamp exactly at 1996 hour 3
Date: 2016-06-08 20:37:33
Message-ID: 20160608203733.5798.44629@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14182
Logged by: Olmo Zavala
Email address: olmozavala(at)gmail(dot)com
PostgreSQL version: 9.4.6
Operating system: Ubuntu 16.04
Description:

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2016-06-08 21:39:52 Re: BUG #14182: Wrong time stamp exactly at 1996 hour 3
Previous Message Eric Worden 2016-06-08 19:11:32 Fwd: BUG #14181: pg_upgrade: operator family "btree_hstore_ops" does not exist