Adding a month to a date in T SQL

Question

How can I add one month to a date that I am checking under the where clause?

select *
from Reference
where reference_dt + 1 month

Answer 1

SELECT * 
FROM Reference 
WHERE reference_dt = DATEADD(MONTH, 1, another_date_reference)

Answer 2

You can use DATEADD function with the following syntax

DATEADD (datepart, number, date)

In your case, the code would look like this:

...
WHERE reference_dt = DATEADD(MM, 1, reference_dt)

Answer 3

Use DATEADD:

DATEADD(month, 1, reference_dt)