小记存储过程中经常用到的本周,本月,本年函数
作者: 来源: 发布时间: 2010-06-05 16:53 点击:
次
1 Dateadd (wk, datediff (wk, 0 , getdate ()), - 1 ) 2 Dateadd (wk, datediff (wk, 0 , getdate ()), 6 ) 3 4 Dateadd (mm, datediff (mm, 0 , getdate ()), 0 ) 5 Dateadd (ms, - 3 , dateadd (mm, datediff (m, 0 , getdate ()) + 1 , 0 )) 6 7 Dateadd (yy, date
小记存储过程中经常用到的本周,本月,本年函数
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))