Skip to Main Content

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!

How can I validate a date using sql

csphardJun 4 2009 — edited Jun 5 2009
How can I validate a date using sql or pl/sql

select to_date('01/01/2009','mm/dd/yyyy') from dual this is a good date

but how can I check for a bad date


select to_date('0a/01/2009','mm/dd/yyyy') from dual

Howard
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2009
Added on Jun 4 2009
15 comments
42,654 views