摘要：DECLARE @dt varchar(10)SET @dt='2013-03-10'--获取周一SELECT DATEADD(wk, DATEDIFF(dd,0,@dt)/7, 0)--获取周日SELECT DATEADD(wk, DATEDIFF(dd,0,@dt)/7, 6)--季度的第一天SELECT CONVERT(datetime, CONVERT(char(8), DATEADD(Month, DATEPART(Quarter,@dt)*3-Month(@dt)-2, @dt), 120)+'1')--季度的最后一天SELECT DATEADD(D
阅读全文
posted @ 2013-03-12 12:01
