Monday, June 10, 2013

How to Add Days, Month, Year in Date Using Sql Server

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

No comments :

Post a Comment