SQL语句:判断某个时间是周末的语句怎么写?求高手!!

xiao_r888 2012-05-25 01:35:19
我现在要写一个语句,但是不知道怎么写,求高手!!!!!!!!!!!!!!!!
以下是随便几条记录
比如:

id T1 T2 T3
2012-05-20 12:02:35 3 4 5
2012-05-21 12:02:35 3 4 5
2012-05-22 12:02:35 3 4 5
2012-05-23 12:02:35 3 4 5
2012-05-24 12:02:35 3 4 5
2012-05-25 12:02:35 3 4 5
2012-05-26 12:02:35 3 4 5
2012-05-27 12:02:35 3 4 5
2012-05-28 12:02:35 3 4 5
2012-05-29 12:02:35 3 4 5
2012-05-30 12:02:35 3 4 5
.....................................(后面无数条数据)

我现在 要写一条SQL语句 能判断 那一天分别是 周六 、周日、 和周六周日 ? 每个月都一样能自动抓去数据
(备注:时间以数据库表的时间为准,不能取系统时间)

我是新手,没有多少积分,盼望高数指点。。。。急 谢谢 。。。。。
...全文
514 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
AcHerat 2012-05-25
  • 打赏
  • 举报
回复

set datefirst 1

select *
from tb
where datepart(weekday,datecol) between 6 and 7
Mr_Nice 2012-05-25
  • 打赏
  • 举报
回复
SELECT DATEADD(dd,number,GETDATE()) AS '日期',DATEPART(dw,DATEADD(dd,number,GETDATE())) AS '星期'
FROM master..spt_values
WHERE type ='P'
AND number <200


/*
日期 星期
2012-05-25 13:45:04.613 5
2012-05-26 13:45:04.613 6
2012-05-27 13:45:04.613 7
2012-05-28 13:45:04.613 1
2012-05-29 13:45:04.613 2
2012-05-30 13:45:04.613 3
2012-05-31 13:45:04.613 4
2012-06-01 13:45:04.613 5
2012-06-02 13:45:04.613 6
2012-06-03 13:45:04.613 7
2012-06-04 13:45:04.613 1
2012-06-05 13:45:04.613 2
2012-06-06 13:45:04.613 3
2012-06-07 13:45:04.613 4
2012-06-08 13:45:04.613 5
2012-06-09 13:45:04.613 6
2012-06-10 13:45:04.613 7
2012-06-11 13:45:04.613 1
2012-06-12 13:45:04.613 2
2012-06-13 13:45:04.613 3
2012-06-14 13:45:04.613 4
2012-06-15 13:45:04.613 5
2012-06-16 13:45:04.613 6
2012-06-17 13:45:04.613 7
2012-06-18 13:45:04.613 1
2012-06-19 13:45:04.613 2
2012-06-20 13:45:04.613 3
2012-06-21 13:45:04.613 4
2012-06-22 13:45:04.613 5
2012-06-23 13:45:04.613 6
2012-06-24 13:45:04.613 7
2012-06-25 13:45:04.613 1
2012-06-26 13:45:04.613 2
2012-06-27 13:45:04.613 3
2012-06-28 13:45:04.613 4
2012-06-29 13:45:04.613 5
2012-06-30 13:45:04.613 6
2012-07-01 13:45:04.613 7
2012-07-02 13:45:04.613 1
2012-07-03 13:45:04.613 2
2012-07-04 13:45:04.613 3
2012-07-05 13:45:04.613 4
2012-07-06 13:45:04.613 5
2012-07-07 13:45:04.613 6
2012-07-08 13:45:04.613 7
2012-07-09 13:45:04.613 1
2012-07-10 13:45:04.613 2
2012-07-11 13:45:04.613 3
2012-07-12 13:45:04.613 4
2012-07-13 13:45:04.613 5
2012-07-14 13:45:04.613 6
2012-07-15 13:45:04.613 7
2012-07-16 13:45:04.613 1
2012-07-17 13:45:04.613 2
2012-07-18 13:45:04.613 3
2012-07-19 13:45:04.613 4
2012-07-20 13:45:04.613 5
2012-07-21 13:45:04.613 6
2012-07-22 13:45:04.613 7
2012-07-23 13:45:04.613 1
2012-07-24 13:45:04.613 2
2012-07-25 13:45:04.613 3
2012-07-26 13:45:04.613 4
2012-07-27 13:45:04.613 5
2012-07-28 13:45:04.613 6
2012-07-29 13:45:04.613 7
2012-07-30 13:45:04.613 1
2012-07-31 13:45:04.613 2
2012-08-01 13:45:04.613 3
2012-08-02 13:45:04.613 4
2012-08-03 13:45:04.613 5
2012-08-04 13:45:04.613 6
2012-08-05 13:45:04.613 7
2012-08-06 13:45:04.613 1
2012-08-07 13:45:04.613 2
2012-08-08 13:45:04.613 3
2012-08-09 13:45:04.613 4
2012-08-10 13:45:04.613 5
2012-08-11 13:45:04.613 6
2012-08-12 13:45:04.613 7
2012-08-13 13:45:04.613 1
2012-08-14 13:45:04.613 2
2012-08-15 13:45:04.613 3
2012-08-16 13:45:04.613 4
2012-08-17 13:45:04.613 5
2012-08-18 13:45:04.613 6
2012-08-19 13:45:04.613 7
2012-08-20 13:45:04.613 1
2012-08-21 13:45:04.613 2
2012-08-22 13:45:04.613 3
2012-08-23 13:45:04.613 4
2012-08-24 13:45:04.613 5
2012-08-25 13:45:04.613 6
2012-08-26 13:45:04.613 7
2012-08-27 13:45:04.613 1
2012-08-28 13:45:04.613 2
2012-08-29 13:45:04.613 3
2012-08-30 13:45:04.613 4
2012-08-31 13:45:04.613 5
2012-09-01 13:45:04.613 6
2012-09-02 13:45:04.613 7
2012-09-03 13:45:04.613 1
2012-09-04 13:45:04.613 2
2012-09-05 13:45:04.613 3
2012-09-06 13:45:04.613 4
2012-09-07 13:45:04.613 5
2012-09-08 13:45:04.613 6
2012-09-09 13:45:04.613 7
2012-09-10 13:45:04.613 1
2012-09-11 13:45:04.613 2
2012-09-12 13:45:04.613 3
2012-09-13 13:45:04.613 4
2012-09-14 13:45:04.613 5
2012-09-15 13:45:04.613 6
2012-09-16 13:45:04.613 7
2012-09-17 13:45:04.613 1
2012-09-18 13:45:04.613 2
2012-09-19 13:45:04.613 3
2012-09-20 13:45:04.613 4
2012-09-21 13:45:04.613 5
2012-09-22 13:45:04.613 6
2012-09-23 13:45:04.613 7
2012-09-24 13:45:04.613 1
2012-09-25 13:45:04.613 2
2012-09-26 13:45:04.613 3
2012-09-27 13:45:04.613 4
2012-09-28 13:45:04.613 5
2012-09-29 13:45:04.613 6
2012-09-30 13:45:04.613 7
2012-10-01 13:45:04.613 1
2012-10-02 13:45:04.613 2
2012-10-03 13:45:04.613 3
2012-10-04 13:45:04.613 4
2012-10-05 13:45:04.613 5
2012-10-06 13:45:04.613 6
2012-10-07 13:45:04.613 7
2012-10-08 13:45:04.613 1
2012-10-09 13:45:04.613 2
2012-10-10 13:45:04.613 3
2012-10-11 13:45:04.613 4
2012-10-12 13:45:04.613 5
2012-10-13 13:45:04.613 6
2012-10-14 13:45:04.613 7
2012-10-15 13:45:04.613 1
2012-10-16 13:45:04.613 2
2012-10-17 13:45:04.613 3
2012-10-18 13:45:04.613 4
2012-10-19 13:45:04.613 5
2012-10-20 13:45:04.613 6
2012-10-21 13:45:04.613 7
2012-10-22 13:45:04.613 1
2012-10-23 13:45:04.613 2
2012-10-24 13:45:04.613 3
2012-10-25 13:45:04.613 4
2012-10-26 13:45:04.613 5
2012-10-27 13:45:04.613 6
2012-10-28 13:45:04.613 7
2012-10-29 13:45:04.613 1
2012-10-30 13:45:04.613 2
2012-10-31 13:45:04.613 3
2012-11-01 13:45:04.613 4
2012-11-02 13:45:04.613 5
2012-11-03 13:45:04.613 6
2012-11-04 13:45:04.613 7
2012-11-05 13:45:04.613 1
2012-11-06 13:45:04.613 2
2012-11-07 13:45:04.613 3
2012-11-08 13:45:04.613 4
2012-11-09 13:45:04.613 5
2012-11-10 13:45:04.613 6
2012-11-11 13:45:04.613 7
2012-11-12 13:45:04.613 1
2012-11-13 13:45:04.613 2
2012-11-14 13:45:04.613 3
2012-11-15 13:45:04.613 4
2012-11-16 13:45:04.613 5
2012-11-17 13:45:04.613 6
2012-11-18 13:45:04.613 7
2012-11-19 13:45:04.613 1
2012-11-20 13:45:04.613 2
2012-11-21 13:45:04.613 3
2012-11-22 13:45:04.613 4
2012-11-23 13:45:04.613 5
2012-11-24 13:45:04.613 6
2012-11-25 13:45:04.613 7
2012-11-26 13:45:04.613 1
2012-11-27 13:45:04.613 2
2012-11-28 13:45:04.613 3
2012-11-29 13:45:04.613 4
2012-11-30 13:45:04.613 5
2012-12-01 13:45:04.613 6
2012-12-02 13:45:04.613 7
2012-12-03 13:45:04.613 1
2012-12-04 13:45:04.613 2
2012-12-05 13:45:04.613 3
2012-12-06 13:45:04.613 4
2012-12-07 13:45:04.613 5
2012-12-08 13:45:04.613 6
2012-12-09 13:45:04.613 7
2012-12-10 13:45:04.613 1*/
Mr_Nice 2012-05-25
  • 打赏
  • 举报
回复
SET DATEFIRST 1

select datepart(dw,getdate())

--5

22,206

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server 疑难问题
社区管理员
  • 疑难问题社区
  • 尘觉
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧