Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> wrong display of year

wrong display of year

From: grace lim <mglim_at_softhome.net>
Date: Tue, 09 Jan 2001 10:52:36 +0800
Message-Id: <10735.126070@fatcity.com>


gurus,

when i issue a select command to display date in mm/dd/yyyy format , the year 1999 is displayed as 2099.

select to_char(process_date,'MM/DD/YYYY) from TEST;

PROCESS_DATE



01-01-2099
02-03-2000

what can i do to correct this?
Grace Lim
Suy Sing Comm'l Corp.
(063)-02-247-41-34 Received on Mon Jan 08 2001 - 20:52:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US