Forms Date format [message #83192] |
Wed, 20 August 2003 06:18 |
sastry
Messages: 6 Registered: January 2002
|
Junior Member |
|
|
Data type of Opening Date is "DATE" in the Table.
Loaded data through sql loader.
when retrieving data from forms date is beeing shown as
15-aug-1968 instead of 15-aug-1868.
how to solve this problem?
|
|
|
Re: Forms Date format [message #83205 is a reply to message #83192] |
Thu, 21 August 2003 03:59 |
magnetic
Messages: 324 Registered: January 2003
|
Senior Member |
|
|
add this to the when-new-form-instance trigger:
set_application_property(PLSQL_DATE_FORMAT,'DDMMYYYY HH24:MI:SS');
set_application_property(BUILTIN_DATE_FORMAT,'DDMMYYYY HH24:MI:SS');
forms_ddl('ALTER SESSION SET NLS_DATE_FORMAT=''DDMMYYYY HH24:MI:SS''');
|
|
|