例： update cyj_cx_dwjl set xrsj=DATEADD(day, DATEDIFF(day, xrsj, GETDATE()), XRSJ) where CONVERT(VARCHAR(10),xrsj,20)='2019-04-26'; ...
例：
update cyj_cx_dwjl set xrsj=DATEADD(day, DATEDIFF(day, xrsj, GETDATE()), XRSJ) where
CONVERT(VARCHAR(10),xrsj,20)='2019-04-26';
