diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2013-11-17 15:06:50 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2013-11-17 15:06:50 -0500 |
| commit | f901bb50e33ad95593bb68f7b3b55eb2e47607dc (patch) | |
| tree | 59f57745a6e30adb0d41485cbc857b1f0d5977e6 /doc/src | |
| parent | 69c8fbac201652282e18b0e2e301d4ada991fbde (diff) | |
| download | postgresql-f901bb50e33ad95593bb68f7b3b55eb2e47607dc.tar.gz postgresql-f901bb50e33ad95593bb68f7b3b55eb2e47607dc.zip | |
Add make_date() and make_time() functions.
Pavel Stehule, reviewed by Jeevan Chalke and Atri Sharma
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 89f08aff979..a5c808effae 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -6693,6 +6693,48 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); <row> <entry> <indexterm> + <primary>make_date</primary> + </indexterm> + <literal> + <function> + make_date(<parameter>year</parameter> <type>int</type>, + <parameter>month</parameter> <type>int</type>, + <parameter>day</parameter> <type>int</type>) + </function> + </literal> + </entry> + <entry><type>date</type></entry> + <entry> + Create date from year, month and day fields + </entry> + <entry><literal>make_date(2013, 7, 15)</literal></entry> + <entry><literal>2013-07-15</literal></entry> + </row> + + <row> + <entry> + <indexterm> + <primary>make_time</primary> + </indexterm> + <literal> + <function> + make_time(<parameter>hour</parameter> <type>int</type>, + <parameter>min</parameter> <type>int</type>, + <parameter>sec</parameter> <type>double precision</type>) + </function> + </literal> + </entry> + <entry><type>time</type></entry> + <entry> + Create time from hour, minute and seconds fields + </entry> + <entry><literal>make_time(8, 15, 23.5)</literal></entry> + <entry><literal>08:15:23.5</literal></entry> + </row> + + <row> + <entry> + <indexterm> <primary>now</primary> </indexterm> <literal><function>now()</function></literal> |