update t set m02=replace(m02, '.', '-')-- orupdate t set m02=convert(varchar(10), cast(m02 as datetime), 121)