N K wrote: > Check the following statement > select * from table1 where lastupdate <> to_date(lastupdate,'DD-mm-YY')
I gave this a try, and still no go. First I looked at your applic_dt <> to_date(applic_dt,'mmddyy') and though that would return true for every record because a string '040108' is never going to equal a date '2008-04-01' value. So I modified it to try applic_dt <> to_char(to_date(applic_dt,'mmddyy'),'mmddyy') but I still get the same error: 'SQL Error: ORA-01843: not a valid month'. So the problem is still that there are data that can not be converted to a date value with the to_date function and the database throws an error when it process the first one of these invalid records. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3197 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
