To add no.of months to a given date, use the following query
QUERY
SELECT DATEADD(M,2,GETDATE())
RESULT
if current month is august, the result is as follows
2013-10-01 14:57:41.143
QUERY
SELECT DATEADD(M,2,GETDATE())
RESULT
if current month is august, the result is as follows
2013-10-01 14:57:41.143
No comments:
Post a Comment