QUERY/SQL/PLSQL [message #370581] |
Tue, 28 December 1999 11:54 |
m a sivan
Messages: 34 Registered: July 1999
|
Member |
|
|
I have a table which has a field varchar2(6) in which dates are stored in YYYYMM format. We did a load in that and some problem occured and now it has some dates like 1999, 1999-1 etc... How to find out all the erroneous data..
I worte a cursor
select to_date(end_year,'YYYYMM') from tablename
it throws an exception and comes out of the program but doesnot give me all the problematic dates..
ANy help is appreciated
Thanks
Sivan
|
|
|