Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALTERING DATE SETTING

406531Dec 8 2003 — edited Dec 11 2003

Hi everybody
I would like to alter the date in the form for specific format, because the date format is the default date format that is DD-MON-YY, so I want the new format for the date as MM-DD-YYYY, when
I alter the date format in the workstation in the SQL PLUS Prompt as
ALTER SESSION SET NLS_DATE_FORMAT ='DD-MM-YYYY'
Session altered.
But when I login again the SQL Prompt the default date format is return again, and I want the changed date format to be permanent, so how can I do that.
NOTICE
I do not want to use the date format for solving this
Problem .

Best Regards

Jamil

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2004

Added on Dec 8 2003

#forms, #moved-from-devops

13 comments

675 views