Ambiguous language in Table 8.13. Special Date/Time Inputs

PG Doc comments form <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.documentation
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.