SQL Query Where Date Today Minus 7 Days

Question

I have a SQL table of hits to my website called ExternalHits  I track the URL as URLx and the date the page was accessed as Datex  I run this query every week to get the count of total hits from the week before  and every week I have to manually change the  between  dates  Is there some way I can change my query so that the  between  dates are something like TODAY AND TODAY-7  Ijust want to not have to manually change the dates every week       SELECT URLX  COUNT URLx  AS Count     FROM ExternalHits     WHERE datex BETWEEN  02 27 2017  AND  03 05 2017          GROUP BY URLx     ORDER BY Count DESC

User · Answer

You can subtract 7 from the current date with this   WHERE datex BETWEEN DATEADD day  -7  GETDATE    AND GETDATE

User · Answer

Use the following   WHERE datex BETWEEN GETDATE   AND DATEADD DAY  -7  GETDATE     Hope this helps

User · Answer

You can use the CURDATE   and DATE SUB   functions to achieve this    SELECT URLX  COUNT URLx  AS Count FROM ExternalHits WHERE datex BETWEEN DATE SUB CURDATE    INTERVAL 7 DAY  AND CURDATE       GROUP BY URLx ORDER BY Count DESC

User · Answer

Use the built in functions   SELECT URLX  COUNT URLx  AS Count FROM ExternalHits WHERE datex BETWEEN DATE SUB NOW    INTERVAL 7 DAY  AND NOW   GROUP BY URLx ORDER BY Count DESC

User · Answer

Using dateadd to remove a week from the current date   datex BETWEEN DATEADD WEEK -1 GETDATE    AND GETDATE

User · Answer

declare  lastweek datetime declare  now datetime set  now   getdate   set  lastweek   dateadd day -7  now   SELECT URLX  COUNT URLx  AS Count FROM ExternalHits WHERE datex BETWEEN  lastweek AND  now GROUP BY URLx ORDER BY Count DESC

User · Answer

DECLARE  Daysforward int SELECT  Daysforward   25  no of days required  Select   from table name  where CAST  columnDate AS date   lt  DATEADD day 1  Daysforward CAST GETDATE   AS date

[sql] SQL Query Where Date = Today Minus 7 Days

Examples related to sql

Examples related to sql-server

Examples related to database

Examples related to between