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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Year 2000 problem with SQL *Net?

Re: Year 2000 problem with SQL *Net?

From: DistressedCanadian <beck4353NObeSPAM_at_yahoo.com.invalid>
Date: Thu, 18 Nov 1999 06:33:21 -0800
Message-ID: <11f733ec.51ac6780@usw-ex0102-015.remarq.com>


THanks for the tip.

THe database was storing the dates correctly, it was just the client machines that weren't set up properly.

To get them set up, I had to do the following (NT)

add registry entry under:

HKEY_LOCAL_MACHINE-->SOFTWARE-->ORACLE-->NLS_DATE_FORMAT:DD-MON-RR RR handles the 2000 issue while YY does not.

Thanks

Received on Thu Nov 18 1999 - 08:33:21 CST

Original text of this message

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