BUG #12739: to_timestamp function conver string to time incorrectly

From: lstrupinskaya(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12739: to_timestamp function conver string to time incorrectly
Date: 2015-02-05 21:22:31
Message-ID: 20150205212231.24252.12016@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: 12739
Logged by: Liliya
Email address: lstrupinskaya(at)gmail(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Fujii Masao 2015-02-06 00:02:09 Re: pg_receivexlog sometimes fails on first start
Previous Message Heikki Linnakangas 2015-02-05 21:17:46 pg_receivexlog sometimes fails on first start