摘要:
判断当前时间是不是星期天 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 DAT 阅读全文