diff options
| author | Bruce Momjian <bruce@momjian.us> | 2014-01-22 22:26:45 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2014-01-22 22:26:45 -0500 |
| commit | 90afc7d805657f6913935913a5bbd2462da80388 (patch) | |
| tree | 835bc9d7c2fbee39de1c428437aa83654fe24b72 /doc/src | |
| parent | 6668ad1d7004e9420107dda5bab1690193b13bc6 (diff) | |
| download | postgresql-90afc7d805657f6913935913a5bbd2462da80388.tar.gz postgresql-90afc7d805657f6913935913a5bbd2462da80388.zip | |
Add date_trunc('', interval) documentation mention
Report from Eric Howe
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 53021c227d7..e79c479ac31 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -6570,6 +6570,20 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); <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> <primary>extract</primary> </indexterm> <literal><function>extract</function>(<parameter>field</parameter> from |