From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: adh@sanger.ac.uk
Subject: Ambiguous language in Table 8.13. Special Date/Time Inputs
Date: Mon, 08 Jul 2019 10:07:59 +0000
Message-ID: <156258047907.1181.11324468080514061996@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/datatype-datetime.html
Description:
In Table 8.13. Special Date/Time Inputs, the description for the special
values 'today', 'tomorrow' and 'yesterday' uses the word 'midnight' e.g. the
special value 'today' is defined as 'midnight today'. I propose that the
word 'midnight' is ambiguous, because it can be interpreted either as
midnight at the start of the day in question, or midnight at the end of the
day. This ambiguity can be avoided if 'midnight' is replaced by '00:00:00',
or better, '00:00:00 local time'. Astronomers have deprecated the word
'midnight' for many years precisely to avoid this ambiguity.
David Harper
Senior DBA (and former astronomer)
Wellcome Sanger Institute
Cambridge, England
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, adh@sanger.ac.uk
Subject: Re: Ambiguous language in Table 8.13. Special Date/Time Inputs
In-Reply-To: <156258047907.1181.11324468080514061996@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