From efcff3da16a7337abb158db17c4c91e779e84255 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Mon, 3 Jul 2000 16:01:33 +0000
Subject: In the attache is new (correct) version. I add TZ (timezone) support
 for to_char() too.

Karel
---
 doc/src/sgml/func.sgml | 21 ++++++++++++++++-----
 1 file changed, 16 insertions(+), 5 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 0023a28b0a..597be31104 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -785,11 +785,11 @@
        </row>
        <row>
 	<entry>W</entry>
-	<entry>week of month</entry>
+	<entry>week of month (1-5) where first week start on the first day of the month</entry>
        </row> 
        <row>
 	<entry>WW</entry>
-	<entry>week number of year</entry>
+	<entry>week number of year (1-53) where first week start on the first day of the year</entry>
        </row>
        <row>
 	<entry>CC</entry>
@@ -811,6 +811,14 @@
 	<entry>rm</entry>
 	<entry>month in Roman Numerals (I-XII; I=JAN) - lower case</entry>
        </row>
+       <row>
+	<entry>TZ</entry>
+	<entry>timezone string - upper case (not supported in the to_timestamp())</entry>
+       </row>
+       <row>
+	<entry>tz</entry>
+	<entry>timezone string - lower case (not supported in the to_timestamp())</entry>
+       </row>
       </tbody>
      </tgroup>
     </table>
@@ -871,9 +879,12 @@
      <listitem>
       <para>
        <function>to_timestamp</function> and <function>to_date</function>
-       skip blank space if the <literal>FX</literal> option is
-       not used. <literal>FX</literal> must be specified as the first item
-       in the template.
+       skip multiple blank space in converted string if the <literal>FX</literal> option 
+       is not used. <literal>FX</literal> must be specified as the first item
+       in the template; for example 
+       <literal>to_timestamp('2000    JUN','YYYY MON')</literal> is right, but
+       <literal>to_timestamp('2000    JUN','FXYYYY MON')</literal> returns error,
+       because to_timestamp() expects one blank space only.
       </para>
      </listitem>
 
-- 
cgit v1.2.1