Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)归海一刀
published in(发表于) 2014/2/1 0:20:59
小记存储过程中经常用到的本周，本月，本年函数_[SQL，Server教程]

小记存储过程中经常用到的本周，本月，本年函数_[SQL Server教程]

1Dateadd(wk,datediff(wk,0,getdate()),-1)
2Dateadd(wk,datediff(wk,0,getdate()),6)
3
4Dateadd(mm,datediff(mm,0,getdate()),0)
5Dateadd(ms,-3,dateadd(mm,datediff(m,0,getdate())+1,0))
6
7Dateadd(yy,datediff(yy,0,getdate()),0)
8Dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate())+1, 0))
来源：博客园





赞

If you have any requirements, please contact webmaster。(如果有什么要求，请联系站长)




QQ:154298438
QQ:417480759