oracle日期格式数据修改

select * from INVOICE_NEW where ref_no='32308'

update INVOICE_NEW set check_d=to_date('2015/11/16', 'yyyy-mm-dd'),rece_d=to_date('2015/11/16', 'yyyy-mm-dd'),due_d=to_date('2015/12/05', 'yyyy-mm-dd') where ref_no='32678'

update table set datafield = to_date('2009-04-29', 'yyyy-mm-dd')