Use mm/dd/RRRR as your date format.
> -----Original Message-----
> From: grace lim [SMTP:mglim_at_softhome.net]
> Sent: Monday, January 08, 2001 8:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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
> ----------------------
> 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
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: grace lim
> INET: mglim_at_softhome.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jan 09 2001 - 08:30:18 CST
