Home » Developer & Programmer » Forms » Change dinamic date format in forms6i. (Developer 6i)
Change dinamic date format in forms6i. [message #387286] Wed, 18 February 2009 14:03 Go to next message
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 #387289 is a reply to message #387286] Wed, 18 February 2009 14:39 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use FORMS_DDL built-in.
Re: Change dinamic date format in forms6i. [message #387313 is a reply to message #387289] Wed, 18 February 2009 16:24 Go to previous message
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.
Previous Topic: Kindly resolve it on urgent basis
Next Topic: Application( Forms 6i Run Time) should be expired when application( Forms 6i ) is idle for 30 mins
Goto Forum:
  


Current Time: Sun Dec 04 06:39:23 CST 2016

Total time taken to generate the page: 0.27430 seconds