On 6/8/2016 1:37 PM, olmozavala(at)gmail(dot)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