Skip site navigation (1) Skip section navigation (2)

BUG #2885: to_char function

From: "Akio Iwaasa" <iwaasa(at)mxs(dot)nes(dot)nec(dot)co(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2885: to_char function
Date: 2007-01-12 10:22:15
Message-ID: 200701121022.l0CAMFEh039943@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2885
Logged by:          Akio Iwaasa
Email address:      iwaasa(at)mxs(dot)nes(dot)nec(dot)co(dot)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.

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2007-01-12 12:57:56
Subject: Re: BUG #2882: jdbc driver: date returned from a stored proc is incorrect
Previous:From: Devrim GUNDUZDate: 2007-01-12 10:02:28
Subject: Re: BUG #2879: RPM: wrong quoting of error message about

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group