与日期有关sql大全.docVIP

1. 与日期有关sql 大全 2.--本周第一天 3.SELECT DATEADD(Day,1-(DATEPART(Weekday,getdate())+@@DATEFIRST-1)%7,getdate()) 4.--or 5.select dateadd(wk, datediff(wk,0,getdate()), 0) 6.--本周第一天 7.select dateadd(wk, datediff(wk,0,getdate()), 6) 8. 9.--上月第一天 10.SELECT CONVERT(CHAR(10),DATEADD(month,-1,DATEADD(dd,-DAY(GETDATE())+1,GETDATE())),111) 11.--上月最后一天 12.SELECT CONVERT(CHAR(10),DATEADD(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()),0)),111)+ 23:59:59 13.--本月第一天 14.select dateadd(dd,-datepart(dd,getdate())+1,getdate()) 15.--本月最后一天 16.select dateadd(dd,-datepart(dd,getdate()) ,dateadd(m