Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> wrong display of year
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
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
![]() |
![]() |