UPDATE jzcd_wrong_log SET pick_date = to_date('2013-01-03 12:00:00','yyyy-mm-dd hh24:mi:ss') WHERE pick_date >= to_date('2013-01-04' , 'yyyy-MM-dd'); commit;