The following bug has been logged online:
Bug reference: 2885
Logged by: Akio Iwaasa
Email address: iwaasa@mxs.nes.nec.co.jp
PostgreSQL version: 8.2.1
Operating system: Redhat EL ES 3.0
Description: to_char function
Details:
When I've used "to_char" function to convert "Date" to
"century" format text, '2000-01-01' was converted in
the 21st century.
postgres=# select to_char('2000-01-01'::date, 'CC') ;
to_char
---------
21
(1 row)
Regards.