I've tryed to set NLS_DATE_FORMAT in my initorcl.ora
init file, then shut down and restart the database:
Both in my delphi application and in SQL plus i can only display dates as
the following format:
01-JAN-98
What can I do to solve this problem?

Open the Windows registry: REGEDIT;
Select HKEY_LOCAL_MACHINE;
Select SOFTWARE;
Select ORACLE;
Don't select +: Click on ORACLE;
Click on Edit;
Select NEW;
Type is String;
Name is NLS_DATE_FORMAT;
Value is whatever you want, e.g. MM-DD-YYYY;
Don't put the value in caps; the registry supplies them;
Buona fortuna!

John

Fabio VITALE <mc3...@mclink.it> wrote in article
<6lqfbb$c...@forums.borland.com>...