Oracle：把字段datetime类型数据转换成date类型数据

JeeStudy

update tb_name set d_filed = to_date(to_char(d_filed,'YYYY/MM/DD'),'YYYY/MM/DD');