Default TIME ZONE in functions

From: forrest(at)iris(dot)washington(dot)edu
To: pgsql-docs(at)postgresql(dot)org
Subject: Default TIME ZONE in functions
Date: 2017-02-02 21:47:31
Message-ID: 20170202214731.1400.54876@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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.

Browse pgsql-docs by date

  From Date Subject
Next Message Devrim Gündüz 2017-02-02 21:48:31 Re: CentOS 7 incorrect installation location
Previous Message Peter Eisentraut 2017-02-02 21:46:00 Re: instr function with negative parameter