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