Home » RDBMS Server » Server Administration » QUERY/SQL/PLSQL
QUERY/SQL/PLSQL [message #370581] Tue, 28 December 1999 11:54
m a sivan
Messages: 34
Registered: July 1999
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

Previous Topic: is NULL and cursor
Next Topic: Time fields
Goto Forum:

Current Time: Fri Oct 30 02:45:59 CDT 2020