diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-11-16 20:29:16 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-11-16 20:29:16 +0000 |
| commit | 1a908a00b05c9f8f94cebde2551eee50329f38f2 (patch) | |
| tree | 501b94bdd175ed4522abf8b61f66b30c611a293b /doc/src | |
| parent | 9ad53b0463edddccff33bcbb68b3c0e5d76cfa28 (diff) | |
Fix datetime input parsing to accept YYYY-MONTHNAME-DD and related syntaxes,
which had been unintentionally broken by recent changes to tighten up the
DateStyle rules for all-numeric date input. Add documentation and
regression tests for this, too.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 30 |
1 files changed, 27 insertions, 3 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index fbd14373647..82ae3a22fbd 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.130 2003/11/06 22:21:47 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.131 2003/11/16 20:29:16 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> |