34,575
社区成员
发帖
与我相关
我的任务
分享
where DATEPART(weekday, CONVERT(datetime, dtfield, 112)) in (1,7)
set datefirst 1
where datepart(weekday,col) in (6,7)
declare @str varchar(18)
set @str='20100812'
select case when datepart(dw,convert(datetime,@str,120))=1 then '星期天'
when datepart(dw,convert(datetime,@str,120))=7 then '星期六' else '工作日' end
where DATEPART(weekday, CONVERT(datetime, dtfield, 112)) in (1,7)