GetDate() Function in T-SQL

Question

My mind has gone totally blank this morning. I'm creating a proc and need it to pull results with a date-related WHERE clause. The WHERE clause should state that the report should look back two months from GetDate().

This is using T-SQL in SQL Server 2012. The column containing the date for the clause is called [Delivery Date].

Many thanks.

score 2 · Answer 1 · edited May 23 '17 at 11:51

2

Try this

SELECT * 
FROM tableName
WHERE [Delivery Date] < DATEADD(month, -2, GETDATE())

MSDN Link for DATEADD
Similar Question: Stackoverflow link

edited May 23 '17 at 11:51

Community

1
1

answered Jun 06 '13 at 08:14

asifsid88

4,631
20
30

score 2 · Accepted Answer · answered Jun 06 '13 at 08:21

If [Delivery Date] has both date and time and want to consider time as well? then try

SELECT * 
FROM tableName
WHERE [Delivery Date] >= DATEADD(month, -2, GETDATE())

If [Delivery Date] is only a date or ignore the time part? then try

SELECT * 
FROM tableName
WHERE [Delivery Date] >= CONVERT(date, DATEADD(month, -2, GETDATE()))

score 1 · Answer 3 · answered Jun 06 '13 at 08:16

1

2 month ago starting the 1st of the month at 00:00

DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 2, 0)

2 month ago starting the same day of month (if applicable) at the same hour

DATEADD(mm, -2, GETDATE())

answered Jun 06 '13 at 08:16

Serge

6,554
5
30
56

GetDate() Function in T-SQL

3 Answers3