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 > GETDATE()

score 359 · Accepted Answer · answered Mar 24 '11 at 21:20

359

If you are using SQL Server try this:

SELECT * FROM MyTable
WHERE MyDate < DATEADD(month, -2, GETDATE())

Based on your update it would be:

SELECT * FROM FB WHERE Dte <  DATEADD(month, -2, GETDATE())

answered Mar 24 '11 at 21:20

Abe Miessler

82,532
99
305
486

32

If you use MySQL this would become: `MyDate < DATE_ADD(NOW(), INTERVAL -2 MONTH)` – Stefan Feb 27 '14 at 15:51

score 9 · Answer 2 · edited May 14 '13 at 10:50

9

Would something like this work for you?

SELECT * FROM FB WHERE Dte >= DATE(NOW() - INTERVAL 2 MONTH);

edited May 14 '13 at 10:50

RAS

8,100
16
64
86

answered Mar 24 '11 at 21:24

geeknik

1,056
8
10

5

This is a solution for MySQL and he asked for a solution to SQL Server. It does not work on SQL Server. – Gander May 13 '19 at 09:27
2

This is what I needed – Climbs_lika_Spyder Nov 19 '21 at 19:00

score 6 · Answer 3 · answered Feb 01 '17 at 09:53

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 <= @gapPeriod;                               --only older records.

score 2 · Answer 4 · answered May 14 '13 at 08:55

2

SELECT COUNT(1) FROM FB 
WHERE Dte > DATE_SUB(now(), INTERVAL 2 MONTH)

answered May 14 '13 at 08:55

George SEDRA

796
8
11

score 2 · Answer 5 · answered Mar 28 '22 at 15:28

2

I use this on SQL Server:

SELECT 

DATEADD(MONTH,-2,GETDATE()) '- 2 months'

FROM MyTable

answered Mar 28 '22 at 15:28

TheOx

67
7

score 0 · Answer 6 · answered Mar 20 '14 at 12:11

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'

SQL query for today's date minus two months

6 Answers6

Linked

Related