how to check for valid date ?
Hi ,
I have a stored procedure which has an input parameter of varchar datatype. Actually this parameter is a date , now i want to check whether this parameter is a valid date or not. My oracle version is 10g . I tried ISDATE() inbuilt function but my oracle version does not support it.
Can you ppl please help how to do it ?
Regards
Shobhit