Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

checking the validity of date data

kumar73May 5 2011 — edited May 5 2011
Hello Friends ,

I have a date value for a filed x as - 06/16/2009 ( mm/dd/yyyy ) and I am converting to
TO_DATE(TO_CHAR(x),'MM/DD/YYYY') and storing in date type of variable field.

I want to check the date and the condition is if its invalid date , i got to store null value .

Please let me know how to validate this date ? or how to check that the date is invalid ?

thanks/kumar
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2011
Added on May 5 2011
8 comments
1,690 views