On Dec 31, 6:45 am, Swapna <[email protected]> wrote: > Hi Friends, > > I need to verify the date formats of a table that contains columns of > varchar2. > > The table contains date like > > AIRED_TIME | BROADCAST_TIME > 2009-12-16 | 2009-16-12 > 2009-12-15 | 2009-15-12 > 14-12-2009 | 2009-14-12 > 2009-12-13 | 2009-13-12 > 2009-12-11 | 2009-12-11 > > Now, in the table i need to check whether the columns are containg valid > date types. and fetch those records and delete the other records. > > As the high lighted records are not valid. > > Kindly reply with solutions. > > Regards, > Swapna
Kindly provide table DDL so we have the same condiotions you do. Something tells me this 'date' is really a varchar2. David Fitzjarrell -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
