The following bug has been logged on the website:
Bug reference: 16472
Logged by: jesvh
Email address: jesvh.cht@gmail.com
PostgreSQL version: Unsupported/Unknown
Operating system: windows 10
Description:
Hi :
I execute a update SQL as below :
update Table1 set date1=to_timestamp('19790701000000', 'YYYYMMDDHH24MISS')
where .....
date1 is a timestamp type column, the result in DB is 1979-07-01 01:00:00
where come from that '01' hour ?
but if set to other date value, it works correct ....
Is it a special bug ?
