From 371f49bf9f13d8762e6894e0534432aa86c56c92 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 10 Oct 2001 00:02:42 +0000 Subject: Remove gratuitous discrepancy between extract() and date_part(), regarding timezone_hour, timezone_minute vs. tz_hour, tz_minute. Document the former. --- doc/src/sgml/func.sgml | 36 +++++++++++++++++++++++++++++------- 1 file changed, 29 insertions(+), 7 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index bbfb4fd3f09..334a8a9ee59 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ - + Functions and Operators @@ -2800,6 +2800,34 @@ SELECT EXTRACT(SECOND FROM TIME '17:12:28.5'); + + + + timezone_hour + + + The hour component of the time zone offset. + + + + + + timezone_minute + + + The minute component of the time zone offset. + + + week @@ -2838,12 +2866,6 @@ SELECT EXTRACT(YEAR FROM TIMESTAMP '2001-02-16 20:38:40'); - - -- cgit v1.2.3