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 -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
