Horton

Re: Second-granular timezone offset format not documented

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: ysangkok@gmail.com
Cc: pgsql-docs@lists.postgresql.org
Date: 2021-07-05T01:05:19Z
Lists: pgsql-docs

Attachments

PG Doc comments form <noreply@postgresql.org> writes:
> Here is an example of a format that I don't think the documentation
> currently covers:
> janus=> set timezone to 'America/Mexico_City';
> SET
> janus=> select '1920-12-25' :: timestamptz;
>          timestamptz          
> ------------------------------
>  1920-12-25 00:00:00-06:36:36
> (1 row)

Yeah, fair point.  There's a passing mention of fractional-minute
offsets in Appendix B, but the main docs don't cover it at all.
I propose the attached draft patch.

			regards, tom lane

Commits

  1. Doc: add info about timestamps with fractional-minute UTC offsets.