Home » Developer & Programmer » Forms » Date format (Windows XP DB 9i - forms 6i)
Date format [message #375866] Mon, 15 December 2008 03:27 Go to next message
*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
Re: Date format [message #375870 is a reply to message #375866] Mon, 15 December 2008 03:30 Go to previous message
Frank Naude
Messages: 4502
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
Previous Topic: Where can i get Webutil Version 10.1.2.0
Next Topic: conversion from fmx to fmb
Goto Forum:
  


Current Time: Sun Dec 11 00:37:16 CST 2016

Total time taken to generate the page: 0.21294 seconds