Home » Developer & Programmer » Reports & Discoverer » how give start date and end date with format in
how give start date and end date with format in [message #172018] Sat, 13 May 2006 04:01 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
hi master
sir i use to parameter start and end how i set date format
my user give 31012006 auto system change formate and give me data

and how i set date formate in user define parameter

please give me idea

thanking you

aamir

Report message to a moderator

Re: how give start date and end date with format in [message #172215 is a reply to message #172018] Mon, 15 May 2006 09:26 Go to previous message
sheshukl
Messages: 13
Registered: February 2006
Location: Pune
Junior Member
u can use this.

select to_char(to_date('31012006','ddmmrrrr'),'DD-MON-RRRR') from dual

Report message to a moderator

Previous Topic: Grouping of the data retrieved by oracle reports query - urgent
Next Topic: how incress page margin and print 30 record on one page
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 21:19:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.