on 09-17-2008 8:43 AM
Hi,
When running a report against Oracle DB, how to detect an invalid date format, for instance, that is NOT like 'DD-MM-YY'?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Could you please explain your issue a bit more? Where is the date coming from, what do you want to do with it? Is it from a user through a parameter?
For instance, to see (or check) if the below parameter is a right date or not, using a command.
select to_date('{?p_date}','dd-mm-rr')
from dual
When creating the command and adding the parameter, did you choose "Date" as parameter type? This would enforce users entering the date in the correct format.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.