Using The TSQL DATEADD Function

Here is a quick video training on how to use the T-SQL DATEADD function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam.

And here is the sample code to go with the DATEADD video tutorial:

SELECT DATEADD(month, 1, GETDATE())
SELECT DATEADD(month, -1, GETDATE())
SELECT DATEADD(month, 3, GETDATE());

See Also

• Additional Training on my YouTube Channel
• Free SQL Query Training
• 70-461 exam preparation

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!