diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2014-03-04 15:09:43 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2014-03-04 15:09:43 -0300 |
| commit | 84df54b22e8035addc7108abd9ff6995e8c49264 (patch) | |
| tree | bf98f8391df7cae81b338e39d506fd98a3b37f01 /doc/src | |
| parent | af2543e884db06c0beb75010218cd88680203b86 (diff) | |
| download | postgresql-84df54b22e8035addc7108abd9ff6995e8c49264.tar.gz postgresql-84df54b22e8035addc7108abd9ff6995e8c49264.zip | |
Constructors for interval, timestamp, timestamptz
Author: Pavel Stěhule, editorialized somewhat by Álvaro Herrera
Reviewed-by: Tomáš Vondra, Marko Tiikkaja
With input from Fabrízio de Royes Mello, Jim Nasby
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 77 |
1 files changed, 77 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index d344b3a894a..a1f627cbd6c 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -6723,6 +6723,32 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); <row> <entry> <indexterm> + <primary>make_interval</primary> + </indexterm> + <literal> + <function> + make_interval(<parameter>years</parameter> <type>int</type> DEFAULT 0, + <parameter>months</parameter> <type>int</type> DEFAULT 0, + <parameter>weeks</parameter> <type>int</type> DEFAULT 0, + <parameter>days</parameter> <type>int</type> DEFAULT 0, + <parameter>hours</parameter> <type>int</type> DEFAULT 0, + <parameter>mins</parameter> <type>int</type> DEFAULT 0, + <parameter>secs</parameter> <type>double precision</type> DEFAULT 0.0) + </function> + </literal> + </entry> + <entry><type>interval</type></entry> + <entry> + Create interval from years, months, weeks, days, hours, minutes and + seconds fields + </entry> + <entry><literal>make_interval(days := 10)</literal></entry> + <entry><literal>10 days</literal></entry> + </row> + + <row> + <entry> + <indexterm> <primary>make_time</primary> </indexterm> <literal> @@ -6744,6 +6770,57 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); <row> <entry> <indexterm> + <primary>make_timestamp</primary> + </indexterm> + <literal> + <function> + make_timestamp(<parameter>year</parameter> <type>int</type>, + <parameter>month</parameter> <type>int</type>, + <parameter>day</parameter> <type>int</type>, + <parameter>hour</parameter> <type>int</type>, + <parameter>min</parameter> <type>int</type>, + <parameter>sec</parameter> <type>double precision</type>) + </function> + </literal> + </entry> + <entry><type>timestamp</type></entry> + <entry> + Create timestamp from year, month, day, hour, minute and seconds fields + </entry> + <entry><literal>make_timestamp(1-23, 7, 15, 8, 15, 23.5)</literal></entry> + <entry><literal>2013-07-15 08:15:23.5</literal></entry> + </row> + + <row> + <entry> + <indexterm> + <primary>make_timestamptz</primary> + </indexterm> + <literal> + <function> + make_timestamptz(<parameter>year</parameter> <type>int</type>, + <parameter>month</parameter> <type>int</type>, + <parameter>day</parameter> <type>int</type>, + <parameter>hour</parameter> <type>int</type>, + <parameter>min</parameter> <type>int</type>, + <parameter>sec</parameter> <type>double precision</type>, + <optional> <parameter>timezone</parameter> <type>text</type> </optional>) + </function> + </literal> + </entry> + <entry><type>timestamp with time zone</type></entry> + <entry> + Create timestamp with time zone from year, month, day, hour, minute + and seconds fields. When <parameter>timezone</parameter> is not specified, + then current time zone is used. + </entry> + <entry><literal>make_timestamp(1-23, 7, 15, 8, 15, 23.5)</literal></entry> + <entry><literal>2013-07-15 08:15:23.5+01</literal></entry> + </row> + + <row> + <entry> + <indexterm> <primary>now</primary> </indexterm> <literal><function>now()</function></literal> |