mysql YearWeek() 不起作用

Question

我正在尝试从数据库中获取本周内的所有数据..如果该周已经结束，我希望显示下周的数据而不显示上周的数据....

这是我的代码:我尝试使用YearWeek()

            Select
                systemusers.FirstName,
                systemusers.MiddleName,
                systemusers.LastName, 
                temperaturelogs.DateTime,
                Locations.Description,
                temperaturelogs.UnitID,
                temperaturelogs.Temperature,
                temperaturelogs.Humidity
            From temperaturelogs 
            Inner Join Locations 
            On temperaturelogs.LocationID = Locations.LocationID
            Inner Join SystemUsers
            On temperaturelogs.Encoder = systemusers.UserID
            Where
            YEARWEEK('3/21/2016') = YEARWEEK(NOW())
            AND
            temperaturelogs.Encoder = 2 Order By temperaturelogs.DateTime DESC

Answer 1

基于从周一中午 12:00 到周日晚上 11:59:59.999 的一周

Where YourColumn >= DATEADD(wk, DATEDIFF(wk, 0, GETDATE() -1), 0)