SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query

SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query

This blog shows how to do an decrease a date value to 4 months in the output using SQL Query

Example:

SELECT DATEADD(mm, -4, '8/1/2011')

The expected result would be 2011-04-01 00:00:00.000