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!