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