Home » Developer & Programmer » Forms » date format DD / MM / YYYY (oracle forms 10g ,win xp pack 2)
date format DD / MM / YYYY [message #580531] Mon, 25 March 2013 12:47 Go to next message
goldray
Messages: 104
Registered: December 2012
Senior Member
Hi,
I have a column of type date in my DB, I want to display it in this format:
DD / MM / YYYY

this my code:
execute_query;

Re: date format DD / MM / YYYY [message #580536 is a reply to message #580531] Mon, 25 March 2013 13:02 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
to_char(<datecol>, 'DD/MM/YYYY')

Regards
Michel
Re: date format DD / MM / YYYY [message #580561 is a reply to message #580536] Mon, 25 March 2013 16:51 Go to previous messageGo to next message
Littlefoot
Messages: 19697
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Put that format mask into item's "Format Mask" property.
Re: date format DD / MM / YYYY [message #580569 is a reply to message #580561] Mon, 25 March 2013 22:10 Go to previous messageGo to next message
goldray
Messages: 104
Registered: December 2012
Senior Member
Thank you Mr.Littlefoot
Re: date format DD / MM / YYYY [message #583063 is a reply to message #580531] Thu, 25 April 2013 05:02 Go to previous messageGo to next message
SandeepS
Messages: 12
Registered: April 2013
Junior Member
If you are entering 01/01/01 in the date field,
dd-mm-yyyy format mask will give the output as 01-01-0001

You can also give dd-mm-rrrr will give the correct output 01-01-2001




Thanks & Regards
Re: date format DD / MM / YYYY [message #583075 is a reply to message #583063] Thu, 25 April 2013 08:00 Go to previous messageGo to next message
joy_division
Messages: 4530
Registered: February 2005
Location: East Coast USA
Senior Member
I don't think that was the question.
It would seem to me OP wants to "display" their DATA column in a different format.
Or else, how would oracle know one is entering dd/mm/yyy vs. mm/dd/yyyy.
Re: date format DD / MM / YYYY [message #583107 is a reply to message #583075] Thu, 25 April 2013 22:43 Go to previous message
SandeepS
Messages: 12
Registered: April 2013
Junior Member
yes I got it. I just wanted to add this if it could help someone . it's as simple as that!!!
Previous Topic: time in oracle form 10g
Next Topic: Insert the date and time automatically in table
Goto Forum:
  


Current Time: Fri Oct 24 11:23:31 CDT 2014

Total time taken to generate the page: 0.17478 seconds