summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/datatype.sgml30
1 files changed, 27 insertions, 3 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index 26043b4fc29..676dcba1bbf 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.128.2.2 2003/11/06 22:21:55 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.128.2.3 2003/11/16 20:29:34 tgl Exp $
-->
<chapter id="datatype">
@@ -1464,7 +1464,7 @@ SELECT b, char_length(b) FROM test2;
</row>
<row>
<entry>1999-01-08</entry>
- <entry>ISO 8601, January 8 in any mode
+ <entry>ISO 8601; January 8 in any mode
(recommended format)</entry>
</row>
<row>
@@ -1485,6 +1485,30 @@ SELECT b, char_length(b) FROM test2;
</entry>
</row>
<row>
+ <entry>1999-Jan-08</entry>
+ <entry>January 8 in any mode</entry>
+ </row>
+ <row>
+ <entry>Jan-08-1999</entry>
+ <entry>January 8 in any mode</entry>
+ </row>
+ <row>
+ <entry>08-Jan-1999</entry>
+ <entry>January 8 in any mode</entry>
+ </row>
+ <row>
+ <entry>99-Jan-08</entry>
+ <entry>January 8 in <literal>YMD</> mode, else error</entry>
+ </row>
+ <row>
+ <entry>08-Jan-99</entry>
+ <entry>January 8, except error in <literal>YMD</> mode</entry>
+ </row>
+ <row>
+ <entry>Jan-08-99</entry>
+ <entry>January 8, except error in <literal>YMD</> mode</entry>
+ </row>
+ <row>
<entry>19990108</entry>
<entry>ISO 8601; January 8, 1999 in any mode</entry>
</row>
@@ -1625,7 +1649,7 @@ SELECT b, char_length(b) FROM test2;
</row>
<row>
<entry><literal>zulu</literal></entry>
- <entry>Military abbreviation for GMT</entry>
+ <entry>Military abbreviation for UTC</entry>
</row>
<row>
<entry><literal>z</literal></entry>