Database Administration (MOSC)

MOSC Banner

Using Date Parameters in SQL*Plus report (as Concurrent Program)

edited Jan 5, 2010 3:57PM in Database Administration (MOSC) 9 commentsAnswered
 Im trying to write a SQL*Query as a report to install in the concurrent manager.
The report contains date parameters and I am using a Standard Date validation set.  
However because each user can use different date formats when they submit the report I cannot use a standard to_date in the SQL.

Is there an easy way to convert to a date when you don't know what the format being passed in is?

and c.check_date between to_date('&&STARTDATE','DD-MON-YYYY')
                                    and to_date('&&ENDDATE','DD-MON-YYYY')


Thanks,
Mary

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center