From 2a34134b6c5a46d8f905a82af51c55a7ec91ecac Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Thu, 6 Sep 2001 03:22:42 +0000
Subject:  - new to_char(interval, text)  - new millisecond (ms) and
 microsecond (us) support  - more robus parsing from string - used is
 separator checking for    non-exact formats like to_date('2001-9-1',
 'YYYY-MM-DD')  - SGML docs are included

Karel Zak
---
 doc/src/sgml/func.sgml | 33 ++++++++++++++++++++++++++++++++-
 1 file changed, 32 insertions(+), 1 deletion(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 2c2daa11a02..39996e54c39 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -1,4 +1,4 @@
-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.68 2001/08/31 07:45:09 ishii Exp $ -->
+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.69 2001/09/06 03:22:41 momjian Exp $ -->
 
 <chapter id="functions">
  <title>Functions and Operators</title>
@@ -1564,6 +1564,12 @@
 	<entry>convert timestamp to string</entry>
 	<entry>to_char(timestamp 'now','HH12:MI:SS')</entry>
        </row>
+       <row>
+	<entry>to_char(interval, text)</entry>
+	<entry>text</entry>
+	<entry>convert interval to string</entry>
+	<entry>to_char(interval '15h 2m 12s','HH24:MI:SS')</entry>
+       </row>
        <row>
 	<entry>to_char(int, text)</entry>
 	<entry>text</entry>
@@ -1645,6 +1651,14 @@
 	<entry>SS</entry>
 	<entry>second (00-59)</entry>
        </row>
+       <row>
+	<entry>MS</entry>
+	<entry>millisecond (000-999)</entry>
+       </row>
+       <row>
+	<entry>US</entry>
+	<entry>microsecond (000000-999999)</entry>
+       </row>
        <row>
 	<entry>SSSS</entry>
 	<entry>seconds past midnight (0-86399)</entry>
@@ -1911,6 +1925,23 @@
        <literal>to_date('20000Nov31', 'YYYYMonDD')</literal>.
       </para>
      </listitem>
+
+     <listitem>
+      <para>
+       Millisecond <literal>MS</literal> and microcesond <literal>US</literal>
+       values are in conversion from string to timestamp used as part of
+       second after decimal point. For example 
+       <literal>to_timestamp('12:3', 'SS:MS')</literal> is not 3 milliseconds,
+       but 300, because the conversion count it as <literal>12 + 0.3</literal>.
+       It means for format 'SS:MS' is '12:3' or '12:30' or '12:300' same
+       number of miliceconds. For the three milliseconds must be used
+       '12:003' that the counversion count as
+       <literal> 12 + 0.003 = 12.003 seconds </literal>. Here is a more 
+       complex example: 
+       <literal>to_timestamp('15:12:02.020.001230','HH:MI:SS.MS.US')</literal>
+       is 15 hours, 12 minutes, 2.021230 seconds. 
+      </para>
+     </listitem>
     </itemizedlist>
    </para>
 
-- 
cgit v1.2.3