OraFAQ Forum: Forms » date format DD / MM / YYYY

Home » Developer & Programmer » Forms » date format DD / MM / YYYY (oracle forms 10g ,win xp pack 2)

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

date format DD / MM / YYYY [message #580531]

Mon, 25 March 2013 12:47

goldray
Messages: 108
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;

Report message to a moderator

Re: date format DD / MM / YYYY [message #580536 is a reply to message #580531]

Mon, 25 March 2013 13:02

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

to_char(<datecol>, 'DD/MM/YYYY')

Regards
Michel

Report message to a moderator

Re: date format DD / MM / YYYY [message #580561 is a reply to message #580536]

Mon, 25 March 2013 16:51

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Put that format mask into item's "Format Mask" property.

Report message to a moderator

Re: date format DD / MM / YYYY [message #580569 is a reply to message #580561]

Mon, 25 March 2013 22:10

goldray
Messages: 108
Registered: December 2012

Senior Member

Thank you Mr.Littlefoot

Report message to a moderator

Re: date format DD / MM / YYYY [message #583063 is a reply to message #580531]

Thu, 25 April 2013 05:02

SandeepS
Messages: 15
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

Report message to a moderator

Re: date format DD / MM / YYYY [message #583075 is a reply to message #583063]

Thu, 25 April 2013 08:00

joy_division
Messages: 4963
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.

Report message to a moderator

Re: date format DD / MM / YYYY [message #583107 is a reply to message #583075]

Thu, 25 April 2013 22:43

SandeepS
Messages: 15
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!!!

Report message to a moderator

Previous Topic:	time in oracle form 10g
Next Topic:	Insert the date and time automatically in table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 17:47:17 CDT 2024