OraFAQ Forum: Forms » Date format

Home » Developer & Programmer » Forms » Date format (Windows XP DB 9i - forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Date format [message #375866]

Mon, 15 December 2008 03:27

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

Hi guyz,
anyone help me in this please
How to set the default date to DD/MON/YYYY if user put dd/mm/yyyy or dd/mm/yy what ever user enter date in date_item it will convert to DD/MON/YYYY how can i do this?

Regards

Report message to a moderator

Re: Date format [message #375870 is a reply to message #375866]

Mon, 15 December 2008 03:30

Frank Naude
Messages: 4590
Registered: April 1998

Senior Member

Use DD/MON/RRRR. Example:

SQL> SELECT TO_DATE('15/Dec/2008', 'DD/MON/RRRR') FROM dual;

TO_DATE('
---------
15-DEC-08

SQL> SELECT TO_DATE('15/Dec/08', 'DD/MON/RRRR') FROM dual;

TO_DATE('
---------
15-DEC-08

Report message to a moderator

Previous Topic:	Where can i get Webutil Version 10.1.2.0
Next Topic:	conversion from fmx to fmb

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 09:10:42 CST 2025