Home » Developer & Programmer » Forms » Default format of sysdate in forms 6i (forms 6i, windows xp)
Default format of sysdate in forms 6i [message #289285] Thu, 20 December 2007 09:45 Go to next message
Messages: 1
Registered: December 2007
Location: chennai
Junior Member
Hi all,

when i write a statement like

select sysdate into :m_date from dual;

in forms 6i, i get value of :m_date in the format of

My nls_date_format is DD/MM/YYYY and NLS_LANG is American.

Datatype of :m_date is date and size is 11.

can anyone please let me know how to get sysdate in the format of nls_date_format.


Re: Default format of sysdate in forms 6i [message #289305 is a reply to message #289285] Thu, 20 December 2007 11:17 Go to previous message
Messages: 21146
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If :m_date is a DATE item (and it should be a DATE), set its format mask to reflect your desire. If it is a CHARACTER (and no, it shouldn't be a character), then use the TO_CHAR function and
SELECT TO_CHAR(sysdate, 'dd-mon-yy') INTO :m_date FROM dual
Previous Topic: Search button or engine
Next Topic: calling report from forms
Goto Forum:

Current Time: Wed Aug 16 18:48:08 CDT 2017

Total time taken to generate the page: 0.09014 seconds