diff options
| -rw-r--r-- | doc/src/sgml/func.sgml | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 67d802b02c2..d2011634075 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -9942,6 +9942,20 @@ SELECT date_trunc('hour', INTERVAL '3 days 02:47:33'); </para> <para> +<synopsis> +date_trunc(<replaceable>stride</replaceable>, <replaceable>source</replaceable>, <replaceable>origin</replaceable>) +</synopsis> + <replaceable>source</replaceable> is a value expression of type + <type>timestamp</type> or <type>timestamp with time zone</type>. (Values + of type <type>date</type> are cast automatically to + <type>timestamp</type>.) <replaceable>stride</replaceable> is a value + expression of type <type> interval</type>. The return value is likewise + of type <type>timestamp</type> or <type>timestamp with time zone</type>, + and it marks the beginning of the bin into which the + <replaceable>source</replaceable> is placed. + </para> + + <para> Examples: <screen> SELECT date_bin('15 minutes', TIMESTAMP '2020-02-11 15:44:17', TIMESTAMP '2001-01-01'); @@ -9959,6 +9973,10 @@ SELECT date_bin('15 minutes', TIMESTAMP '2020-02-11 15:44:17', TIMESTAMP '2001-0 </para> <para> + Negative intervals are allowed and are treated the same as positive intervals. + </para> + + <para> The <parameter>stride</parameter> interval cannot contain units of month or larger. </para> |