postgres.git / summary / log / commit / refs
commit ccdfac8286486e47e253065004b79cc2449581cb
Author: Bruce Momjian <bruce@momjian.us>
Date: Mon Oct 07 21:26:46 2019 +0000
First released in: 13.0, 9.4.25, 9.5.20, 9.6.16, 10.11, 11.6, 12.1
docs: clarify that today/tomorrow/yesterday is at 00:00
This should help people clearly know that these days start at midnight.
Reported-by: David Harper
Discussion: https://postgr.es/m/156258047907.1181.11324468080514061996@wrigleys.postgresql.org
Backpatch-through: 9.4
doc/src/sgml/datatype.sgml | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index 0624c7f9a19..694843ea71e 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -2163,17 +2163,17 @@ January 8 04:05:06 1999 PST
<row>
<entry><literal>today</literal></entry>
<entry><type>date</type>, <type>timestamp</type></entry>
- <entry>midnight today</entry>
+ <entry>midnight (<literal>00:00</literal>) today</entry>
</row>
<row>
<entry><literal>tomorrow</literal></entry>
<entry><type>date</type>, <type>timestamp</type></entry>
- <entry>midnight tomorrow</entry>
+ <entry>midnight (<literal>00:00</literal>) tomorrow</entry>
</row>
<row>
<entry><literal>yesterday</literal></entry>
<entry><type>date</type>, <type>timestamp</type></entry>
- <entry>midnight yesterday</entry>
+ <entry>midnight (<literal>00:00</literal>) yesterday</entry>
</row>
<row>
<entry><literal>allballs</literal></entry>
[parent: 7eefec61c9e3]