SQL Server- Get Date 6 months in past

Question

Hey how would I get data for a date column that's older than 6 months? select * from myTable where dateColumn > Thanks

Accepted Answer

Use DATEDIFF function.

Read more here: https://msdn.microsoft.com/en-us/library/ms189794.aspx

```
SELECT *
FROM myTable
WHERE DATEDIFF(MM, dateColumn, GETDATE()) > 6
```

Solution