OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » date format (reports 6i)

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

date format [message #573715]

Wed, 02 January 2013 11:57

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

I have a date column , and i want to show the date in 'DD/MM/YYYY' format for eg days with 2 digit or comming properly but when it comes to single digit the 0 is not comming for example 4/11/2012 should come as 04/11/2012 like 16/11/2012 , i even did the conversion like to_char(rh_dt,'DD/MM/RRRR').

Report message to a moderator

[Message index]

		date format By: arif_md2009 on Wed, 02 January 2013 11:57
		Re: date format By: Littlefoot on Wed, 02 January 2013 12:03
		Re: date format By: arif_md2009 on Wed, 02 January 2013 22:22
		Re: date format By: Littlefoot on Thu, 03 January 2013 00:10
		Re: date format By: arif_md2009 on Thu, 03 January 2013 00:42
		Re: date format By: Rizwi on Wed, 18 June 2014 08:01
		Re: date format By: cookiemonster on Wed, 18 June 2014 08:09

Previous Topic:	Oracle Report issue
Next Topic:	convert tabular report to group report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 02:41:49 CDT 2024