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