select DATEADD(DAY, 1, getdate())
Result : 2013-06-11 16:22:33.920
select DATEADD(MONTH, 1, getdate())
Result : 2013-07-10 16:22:33.920
select DATEADD(YEAR, 1, getdate())
Result : 2014-06-10 16:22:33.920
Result : 2013-06-11 16:22:33.920
select DATEADD(MONTH, 1, getdate())
Result : 2013-07-10 16:22:33.920
select DATEADD(YEAR, 1, getdate())
Result : 2014-06-10 16:22:33.920
No comments :
Post a Comment