mysql查询全年星期_数据库查询显示一年中所有的周一到周五的数据

select count(*) from weixiuguanli where weixiuzt= ‘待维修‘

select * from weixiuguanli where weixiuzt= ‘待维修‘

select top 5 * from WeiXiuGuanLi Order By baoxiusj Desc --按时间升降

select * from weixiuguanli where baoxiusj >= date() and baoxiusj < DateAdd(‘d‘, 1, date()) and weixiuzt=‘已维修‘

select * from weixiuguanli where (DateDiff(‘d‘,baoxiusj,Date())=0) -- d 一天

select * from weixiuguanli where (DateDiff(‘w‘,baoxiusj,Date())=0) -- w 一7天

select * from weixiuguanli where (DateDiff(‘m‘,baoxiusj,Date())=0) -- m 一月

select * from weixiuguanli where (DateDiff(‘d‘,baoxiusj,Date())=1) -- d 昨天

select * from weixiuguanli where (DateDiff(‘q‘,baoxiusj,Date())=0) -- q 季度

select * from weixiuguanli where (DateDiff(‘yyyy‘,baoxiusj,Date())=0) -- y 今年度

select * from weixiuguanli where (DateDiff(‘yyyy‘,baoxiusj,Date())=1) -- y 去年度

select * from weixiuguanli where datediff(‘w‘,baoxiusj,now()+1)=0 -- w 星期一到星期天

--========================================================

本月记录

select*from[table]wheredatediff(‘m‘,theDate,now())=0

本周记录

select*from[table]wheredatediff(‘w‘,theDate,now())=0

本日记录

select*from[table]wheredatediff(‘d‘,theDate,now())=0

本年记录

select*from[table]wheredatediff(‘y‘,theDate,now())=0

--sql

表名为：tableName

时间字段名为：theDate

查询本月的记录

select*fromtableNamewhereDATEPART(mm,theDate)=DATEPART(mm,GETDATE())andDATEPART(yy,theDate)=DATEPART(yy,GETDATE())

查询本周的记录

select*fromtableNamewhereDATEPART(wk,theDate)=DATEPART(wk,GETDATE())andDATEPART(yy,theDate)=DATEPART(yy,GETDATE())

查询本季的记录

select*fromtableNamewhereDATEPART(qq,theDate)=DATEPART(qq,GETDATE())andDATEPART(yy,theDate)=DATEPART(yy,GETDATE())

其中:GETDATE()是获得系统时间的函数。