How to select data from 30 days

Question

I have query   SELECT name FROM   SELECT name FROM  Hist answer WHERE id city  34324  AND datetime  gt   DATE SUB CURRENT DATE  INTERVAL 1 MONTH  UNION ALL SELECT name FROM  Hist internet WHERE id city  34324  AND datetime  gt   DATE SUB CURRENT DATE  INTERVAL 1 MONTH    x GROUP BY name ORDER BY name   But DATE SUB is a MySQL function and I need function for MsSQL 2008  Tell me please how to select data from 30 days by using MsSQL 2008   P S   Data type of  datetime is smalldatetime

User · Answer

Try this   Using this you can select date by last 30 days    SELECT DATEADD DAY -30 GETDATE

User · Answer

For those who could not get DATEADD to work  try this instead    NOW    - INTERVAL 1 MONTH

User · Answer

You should be using DATEADD is Sql server so if try this simple select you will see the affect  Select DATEADD Month  -1  getdate      Result  2013-04-20 14 08 07 177   in your case try this query  SELECT name FROM   SELECT name FROM  Hist answer WHERE id city  34324  AND datetime  gt   DATEADD month -1 GETDATE    UNION ALL SELECT name FROM  Hist internet WHERE id city  34324  AND datetime  gt   DATEADD month -1 GETDATE      x GROUP BY name ORDER BY name

User · Answer

Short version for easy use   SELECT    FROM  TableName  t WHERE t  DateColumnName   gt   DATEADD month  -1  GETDATE      DATEADD and GETDATE are available in SQL Server starting with 2008 version  MSDN documentation  GETDATE and DATEADD

[sql] How to select data from 30 days?

Examples related to sql

Examples related to sql-server-2008

Examples related to keyword

Examples related to smalldatetime