From 90afc7d805657f6913935913a5bbd2462da80388 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Wed, 22 Jan 2014 22:26:45 -0500
Subject: [PATCH] Add date_trunc('', interval) documentation mention

Report from Eric Howe
---
 doc/src/sgml/func.sgml | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 53021c227d..e79c479ac3 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -6567,6 +6567,20 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})');
         <entry><literal>2001-02-16 20:00:00</literal></entry>
        </row>
 
+       <row>
+        <entry>
+         <indexterm>
+          <primary>date_trunc</primary>
+         </indexterm>
+         <literal><function>date_trunc(<type>text</type>, <type>interval</type>)</function></literal>
+        </entry>
+        <entry><type>interval</type></entry>
+        <entry>Truncate to specified precision; see also <xref linkend="functions-datetime-trunc">
+        </entry>
+        <entry><literal>date_trunc('hour', interval '2 days 3 hours 40 minutes')</literal></entry>
+        <entry><literal>2 days 03:00:00</literal></entry>
+       </row>
+
        <row>
         <entry>
          <indexterm>
-- 
2.40.0