Re: wrong display of year

Grace,

  Update the column. I think that the display is right, but the data wrong. You may have something with -RR (only two Rs) as NLS_DATE_FORMAT, and the date must have improperly been interpreted on input. Use 4 Rs in your default format as somebody suggested.

Regards,

Stephane Faroult
Oriole Corporation

>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
>

>

--
This mail was sent through http://www.mail-inspector.de
Mail Inspector is a free service of http://www.is-fun.net CHECK OUT !

This mail was sent from host 195.25.229.12