SQL Server Transact Basic to Expert - Decreasing a date and time by 30 Mins using SQL query

SQL Server Transact Basic to Expert - Decreasing a date and time by 30 Mins using SQL query

This blog shows how to do an decrease a date and time value to 30 mins in the output using SQL Query

Example:

SELECT DATEADD(mi, -30, '2011-02-02 22:30:00.000')

The expected result would be 2011-02-02 22:00:00.000