Get last 30 day records from today date in SQL Server

Question

I have small question about SQL Server  how to get last 30 days information from this table   Sample data   Product   Pdate ---------- 2014-11-20 2014-12-12 2014-11-10 2014-12-13 2014-10-12 2014-11-15 2014-11-14 2014-11-16 2015-01-18   Based on this table data i want output like below  pdate ------- 2014-11-20 2014-12-12 2014-12-13 2014-11-16   I tried this query   SELECT    FROM product  WHERE pdate  gt   DATEADD day  -30  getdate       but it now give exactly result  Please tell me how to solve this issue in SQL Server

User · Answer

you can use this to get the data of the last 30 days based on a column   WHERE DATEDIFF dateColumn CURRENT TIMESTAMP  BETWEEN 0 AND 30

User · Answer

This Should Work Fine   SELECT   FROM product  WHERE pdate BETWEEN datetime  now    -30 days   AND datetime  now    localtime

User · Answer

I dont know why all these complicated answers are on here but this is what I would do   where pdate  gt   CURRENT TIMESTAMP -30   OR WHERE CAST PDATE AS DATE   gt   GETDATE   -30

User · Answer

You can use DateDiff for this  The where clause in your query would look like   where DATEDIFF day pdate GETDATE     lt  31

User · Answer

Below query is appropriate for the last 30 days records  Here  I have used a review table and review date is a column from the review table  SELECT   FROM reviews WHERE DATE review date   gt   DATE NOW    - INTERVAL 30 DAY

User · Answer

Add one more condition in where clause  SELECT   FROM  product  WHERE pdate  gt   DATEADD day -30 GETDATE     and   pdate  lt   getdate     Or use DateDiff  SELECT   FROM  product  WHERE DATEDIFF day pdate GETDATE    between 0 and 30

[sql-server] Get last 30 day records from today date in SQL Server

Examples related to sql-server

Examples related to sql-server-2008

Examples related to sql-server-2008-r2

Examples related to sql-server-2012