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

Karthikeyan Anbarasan
13y
5.9k
0
0

Blog

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

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

Up Next

SQL Server Transact Basic to Expert - Incrementing a date value (Year) using query

Ebook Download

View all

Basics of SQL Server

Read by 1.5k people

Download Now!

Learn

View all