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: (view raw, whole thread or download thread mbox)
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

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') ;
 (1 row)



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-2017 The PostgreSQL Global Development Group