BUG #2885: to_char function - Mailing list pgsql-bugs

From Akio Iwaasa
Subject BUG #2885: to_char function
Date
Msg-id 200701121022.l0CAMFEh039943@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #2885: to_char function  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #2885: to_char function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: Ravi Periasamy
Date:
Subject: Re: BUG #2882: jdbc driver: date returned from a stored proc is incorrect
Next
From: "Zubkovsky, Sergey"
Date:
Subject: PG unexpected crash