| Change dinamic date format in forms6i. [message #387286] |
Wed, 18 February 2009 14:03  |
johnnyof
Messages: 2
Registered: January 2006
|
Junior Member |
|
|
Hi everyone.
How i can to change dinamically the date format in forms??
In Sql Plus I do that using following sentence:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/RRRR';
How i can to do that or simmilar in forms 6i, or database program?
Thanks.
Johnny
|
|
|
|
|
|
| Re: Change dinamic date format in forms6i. [message #387313 is a reply to message #387289] |
Wed, 18 February 2009 16:24  |
johnnyof
Messages: 2
Registered: January 2006
|
Junior Member |
|
|
Thanks Mr. Littlefoot but Unsuccessfully attempted to do that.
=============================================================
MESSAGE('BEFORE ALTER => TODAY 1: '||SYSDATE);
PAUSE;
FORMS_DDL ('ALTER SESSION SET NLS_DATE_FORMAT = ''DD/MM/YYYY'' ');
IF FORM_SUCCESS THEN
MESSAGE('SUCCESSFULLY => TODAY 2: '||SYSDATE);
ELSE
MESSAGE('FAILED >= ERROR: '||DBMS_ERROR_CODE ||' - '||DBMS_ERROR_TEXT);
END IF;
PAUSE;
=============================================================
Apparently it works but displays the same date format in both messages..
BEFORE ALTER => TODAY 1: 18-FEB-09
SUCCESSFULLY => TODAY 2: 18-FEB-09
WHY?? I expect 18-FEB-09 first and 18/02/2009 later..
Thanks again.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
