Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Year 2000 problem with SQL *Net?
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
![]() |
![]() |