From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: lancetcampbell@gmail.com
Subject: Please add example
Date: Thu, 05 Sep 2019 15:58:22 +0000
Message-ID: <156769910245.1126.4395971697026118289@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/functions-formatting.html
Description:
On this screen:
https://www.postgresql.org/docs/11/functions-formatting.html
Please consider adding this as an example:
to_char( (now()-INTERVAL '10 minutes') AT TIME ZONE
'UTC','YYYY-MM-DD"T"HH24:MI')
Output: 2019-09-05T15:43
Why:
This will demonstrate not only formatting but how to deal with converting
your local timestamp to other timestamps and how to get times relative to
the current time. This is extremely helpful as a way to deal with so many
external system that need UTC time zones like AWS while your database uses
local time zones.
This example would have totally changed how I would have dealt with many
issues in my software. But since the example did not exist I had no idea I
could have went down this path.
Thanks,
Lance
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: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, lancetcampbell@gmail.com
Subject: Re: Please add example
In-Reply-To: <156769910245.1126.4395971697026118289@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