example :
SELECT DATEADD(month, 1, getdate());
https://msdn.microsoft.com/en-us/library/ms186819.aspx
