From 9a54b76b39b89de2f0238a9e4d570972cf758fd8 Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Fri, 12 Jan 2007 23:34:55 +0000
Subject: 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.
---
 doc/src/sgml/func.sgml | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'doc/src')

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>
-- 
cgit v1.2.3