| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Checking for Date Validity.
I have a character column (txtDate) containing date values.
I want to insert records from this column into another
column (dtDate) which is of date datatype.
I get oracle error messages if 1 of the records has an
invalid date. How do I know which row(s) had the
invalid date? Is there an oracle function for
checking if a date is valid or can I write a select statement?
Thanks in advance for your help.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Nov 16 1999 - 12:43:59 CST
 |
 |