From f901bb50e33ad95593bb68f7b3b55eb2e47607dc Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 17 Nov 2013 15:06:50 -0500 Subject: Add make_date() and make_time() functions. Pavel Stehule, reviewed by Jeevan Chalke and Atri Sharma --- doc/src/sgml/func.sgml | 42 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 42 insertions(+) (limited to 'doc/src') 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 @@ -6690,6 +6690,48 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); + + + + make_date + + + + make_date(year int, + month int, + day int) + + + + date + + Create date from year, month and day fields + + make_date(2013, 7, 15) + 2013-07-15 + + + + + + make_time + + + + make_time(hour int, + min int, + sec double precision) + + + + time + + Create time from hour, minute and seconds fields + + make_time(8, 15, 23.5) + 08:15:23.5 + + -- cgit v1.2.3