SQL convert

update OrderH
set Status='2',ConfirmDate=convert(datetime,convert(char(10),getdate(),102)),ConfirmMan=#{confirmman,jdbcType=VARCHAR}
where Status = '1'