BUG #12739: to_timestamp function conver string to time incorrectly - Mailing list pgsql-bugs

From lstrupinskaya@gmail.com
Subject BUG #12739: to_timestamp function conver string to time incorrectly
Date
Msg-id 20150205212231.24252.12016@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #12739: to_timestamp function conver string to time incorrectly  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12739
Logged by:          Liliya
Email address:      lstrupinskaya@gmail.com
PostgreSQL version: 9.3.6
Operating system:   Windows
Description:

When trying to use to_timestamp function to convert string '3/10/2013 2:30'
to timestamp it was actually converted into 3/10/2013 3:30.

Below is select statement:

select to_timestamp('3/10/2013 2:30','MM/DD/YYYY HH24:MI');

it seems that problem was caused by days when daylight time is switched. all
following and preceding hours where properly converted.

pgsql-bugs by date:

Previous
From: barrera@mail.bpa.cu
Date:
Subject: BUG #12743: error in xml conversion
Next
From: anjana1909@gmail.com
Date:
Subject: BUG #12742: non fatal error during istallation