在数据库中,我有一个名为"tbltask"表的"Taskdate"、"Taskname"、"Tid"的列,如果我打开我的网格视图,它必须显示本周分配的任务名称,即)如果我的任务日期包含10月6日至11日之间的任何记录,它必须在网格视图中显示这些记录
我尝试在MSSQL中对此进行查询,但不知道如何在MYSQL中进行查询
MS-SQL查询#1
Select * from Task where Tdate >= dateadd(day, 2-datepart(dw, getdate()), CONVERT(datetime,getdate())) AND tdate < dateadd(day, 9-datepart(dw, getdate()), CONVERT(datetime,getdate()))
MS-SQL查询#2
SELECT * FROM Task WHERE '2014-10-08' BETWEEN DATEADD(WK, DATEDIFF(WK, 0, Tdate), 0) AND DATEADD(WK, DATEDIFF(WK, 0, Tdate) + 1, 0)
试试这个
上周的数据
SELECT * FROM Task
WHERE Taskdate >= curdate() - INTERVAL DAYOFWEEK(curdate())+6 DAY
AND Taskdate < curdate() - INTERVAL DAYOFWEEK(curdate())-1 DAY
本周数据
SELECT * FROM Task
WHERE YEARWEEK(Taskdate) = YEARWEEK(CURRENT_DATE)