Using The TSQL DATEADD Function

Download PDF

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

Posted in 70-461 Training, TSQL Tagged with: , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*

Time limit is exhausted. Please reload CAPTCHA.