From: forrest@iris.washington.edu
To: pgsql-docs@postgresql.org
Subject: Default TIME ZONE in functions
Date: Thu, 02 Feb 2017 21:47:31 +0000
Message-ID: <20170202214731.1400.54876@wrigleys.postgresql.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/7.4/static/functions-formatting.html
Description:
I find the date-time functions Table 9-20 and operators Table 9-29
discussions incomplete in specifying how time zones are handled on inputs
and outputs, so that there are many ambiguities when trying to use these
functions and know exactly what TZ the inputs are interpreted as or implied
and converted to. This page
https://www.postgresql.org/docs/7.4/static/functions-formatting.html has no
mention of time zone in to_date and to_timestamp. Page
https://www.postgresql.org/docs/9.6/static/functions-datetime.html does not
explain what date and timestamp conversion on a string assume for time zone.
In general things work as expected but Ive encountered treacherous cases
where what happens is unexpected because of this lack of clarity.
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: forrest@iris.washington.edu
Subject: Re: Default TIME ZONE in functions
In-Reply-To: <20170202214731.1400.54876@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox