Date format

From: J. Chou <yhchou_at_comp.hkbu.edu.hk>
Date: Thu, 30 Jul 1998 09:20:37 +0800
Message-ID: <35BFCA65.F6A6FB05_at_comp.hkbu.edu.hk>

The application is developed using Designer/Developer Release 1.3. The Date display format is dd/mm/yyyy .

1. The system date display is correct in both Oracle7 UNIX and Oracle8 8.0.3 for NT.
2. The date is retrieved from table.
   ? If the database is Oracle7 for UNIX, it displays the correct format.
   ? In Oracle8 Release 8.0.3 for NT, the display is wrong - dd/mm/00yy.
   

In database instance level of Oracle8 NT, NLS_DATE_FORMAT =’dd-mm-yyyy’ is set already.
This problem happened again. How to solve this problem?

Thank you very much. Received on Thu Jul 30 1998 - 03:20:37 CEST