PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16472
PG VersionUnsupported/Unknown
OSwindows 10
Opened2020-06-01 10:32:04+00
Reported byjesvh
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16472
Logged by:          jesvh
Email address:      (redacted)
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 ?

Messages

DateAuthorSubject
2020-06-01 10:32:04+00PG Bug reporting formBUG #16472: Bug in to_timestamp ?
2020-06-01 12:02:23+00Alexander KorotkovRe: BUG #16472: Bug in to_timestamp ?
2020-06-01 16:18:11+00Tom LaneRe: BUG #16472: Bug in to_timestamp ?
2020-06-02 01:19:32+00=?UTF-8?B?6YSt5pet5a6P?=Re: BUG #16472: Bug in to_timestamp ?