Home » Developer & Programmer » Forms » Forms Date format
Forms Date format [message #83192] Wed, 20 August 2003 06:18 Go to next message
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 Go to previous message
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''');
Previous Topic: Forms Compiling
Next Topic: insertion point
Goto Forum:
  


Current Time: Fri Mar 29 10:54:23 CDT 2024