RE: wrong display of year

  In SQL *PLUS* issue this statement:
ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY'; May not need quotes, I can't remember.

  If that does not work, and/or to make things easier, go into your PC's registry(ORACLE_HOME) and enter a new I think, binary string: NLS_DATE_FORMAT. Set the value to "MM/DD/YYYY".

  Then, you will have to restart SQL *PLUS* or whaterver other tool you are using to access the database.

• Viswalingam Mohan <Viswalingam_Mohan_at_ril.com> wrote:
  >
  >
  > dear all
  > what is this 'mm/dd/rrrr' format i tried it but ??
  >
  >
  >
  > Please respond to ORACLE-L_at_fatcity.com
  >
  > To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > cc: (bcc: Viswalingam Mohan/JAMNAGAR/RIL)
  >
  >
  >
  > known problem,
  > use the RRRR format.
  > 'mm/dd/rrrr'
  >
  > Thanks,
  > Amar Kumar Padhi
  > Software Consultant
  >
  > -----Original Message-----
  > Sent: Tuesday, January 09, 2001 6:50 AM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > 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).
  >
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Viswalingam Mohan
  > INET: Viswalingam_Mohan_at_ril.com
  >
  > 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).
  

  ---