欢迎投稿

今日深度:

SQLServer 把某日期更新到某天,

SQLServer 把某日期更新到某天,


例:

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

www.htsjk.Com true http://www.htsjk.com/Sql_Server/42757.html NewsArticle SQLServer 把某日期更新到某天, 例: update cyj_cx_dwjl set xrsj=DATEADD(day, DATEDIFF(day, xrsj, GETDATE()), XRSJ) where CONVERT(VARCHAR(10),xrsj,20)='2019-04-26';...
相关文章
    暂无相关文章
评论暂时关闭