BUG #16027: Invalid output of to_timestamp - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16027: Invalid output of to_timestamp
Date
Msg-id 16027-8b799f2d11947553@postgresql.org
Whole thread Raw
Responses Re: BUG #16027: Invalid output of to_timestamp
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16027
Logged by:          Jeff Sturm
Email address:      jeff.sturm@helloworld.com
PostgreSQL version: Unsupported/Unknown
Operating system:   CentOS 6.10
Description:

Actual version is 8.4.20.

With a date in year 1904 or earlier, the to_timestamp function outputs
unexpected characters:

template1=# select to_timestamp('19041231','YYYYMMDD');
         to_timestamp
------------------------------
 1904-12-31 00:00:00-05:32:11

Expected is "1904-12-31 00:00:00-06"


pgsql-bugs by date:

Previous
From: Marina Garrido Sanchez
Date:
Subject: Re: BUG #16020: ICU Collations querys
Next
From: Tom Lane
Date:
Subject: Re: BUG #16027: Invalid output of to_timestamp