SQL query for today s date minus two months

Question

I want to select all the records in a table where their date of entry is older then 2 months   Any idea how I can do that   I haven t tried anything yet but I am on this point   SELECT COUNT 1  FROM FB WHERE Dte  gt  GETDATE

User · Accepted Answer

If you are using SQL Server try this   SELECT   FROM MyTable WHERE MyDate  lt  DATEADD month  -2  GETDATE      Based on your update it would be   SELECT   FROM FB WHERE Dte  lt   DATEADD month  -2  GETDATE

User · Answer

SELECT COUNT 1  FROM FB  WHERE Dte  gt  DATE SUB now    INTERVAL 2 MONTH

User · Answer

Would something like this work for you   SELECT   FROM FB WHERE Dte  gt   DATE NOW   - INTERVAL 2 MONTH

User · Answer

SELECT COUNT 1  FROM FB WHERE     Dte BETWEEN CAST YEAR GETDATE    AS VARCHAR 4      -    CAST MONTH DATEADD month  -1  GETDATE     AS VARCHAR 2      -20 00 00 00          AND CAST YEAR GETDATE    AS VARCHAR 4      -    CAST MONTH GETDATE    AS VARCHAR 2      -20 00 00 00

User · Answer

TSQL  Alternative using variable declaration   it might improve Query s readability   DECLARE  gapPeriod DATETIME   DATEADD MONTH -2 GETDATE     --Period Last 2 months   SELECT                FROM          FB as A     WHERE         A Dte  lt    gapPeriod                                --only older records

[sql] SQL query for today's date minus two months

Examples related to sql

Examples related to sql-server