How to add days to the current date?
Just do-
Select (Getdate()+360) As MyDateThere is no need to use dateadd function for adding or subtracting days from a given date. For adding years, months, hours you need the dateadd function.
select dateadd(dd,360,getdate()) will give you correct date as shown below:
2017-09-30 15:40:37.260
I just ran the query and checked:
Dateadd(datepart,number,date)You should use it like this:
select DATEADD(day,360,getdate())Then you will find the same date but different year.