diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-01-12 23:34:55 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-01-12 23:34:55 +0000 |
| commit | 9a54b76b39b89de2f0238a9e4d570972cf758fd8 (patch) | |
| tree | ab5b2fa640ad316d8064caad9b497f68e5063846 /doc/src | |
| parent | 113fbe1264a8b6d757afc54c6df29de80720c7bd (diff) | |
Fix handling of CC (century) format spec in to_date/to_char. According to
standard convention the 21st century runs from 2001-2100, not 2000-2099,
so make it work like that. Per bug #2885 from Akio Iwaasa.
Backpatch to 8.2, but no further, since this is really a definitional
change; users of older branches are probably more interested in stability.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 7617642f200..b9cd00320b4 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.349 2007/01/12 20:06:10 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.350 2007/01/12 23:34:54 tgl Exp $ --> <chapter id="functions"> <title>Functions and Operators</title> @@ -4617,7 +4617,7 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); </row> <row> <entry><literal>CC</literal></entry> - <entry>century component of year (minimum 2 digits)</entry> + <entry>century (2 digits) (The twenty-first century starts on 2001-01-01.)</entry> </row> <row> <entry><literal>J</literal></entry> |