判断当前时间是不是星期天

if datepart(dw, getdate())=1

print 'yes'
else

print 'no'

判断一月内所有星期天

select DATEADD(wk, DATEDIFF(wk,0, dateadd(dd,6-datepart(day,getdate()),getdate()) ), -1)
union all select DATEADD(wk, DATEDIFF(wk,0, dateadd(dd,6-datepart(day,getdate()),getdate()) ), 6)
union all select DATEADD(wk, DATEDIFF(wk,0, dateadd(dd,6-datepart(day,getdate()),getdate()) ), 13)
union all select DATEADD(wk, DATEDIFF(wk,0, dateadd(dd,6-datepart(day,getdate()),getdate()) ), 20)

posted on 2010-11-17 11:09 羽林.Luouy 阅读(792) 评论(0) 编辑收藏举报