How to add days to the current date?

Question

I am attempting to add days to the current date and it's working fine however when I add 360 days to the current date it is giving me the wrong value.

Eg: Current Date is 11/12/2020

And I am adding 360 Days to it, it should give me 11/12/2021, though it is displaying the same date 11/12/2020. the year is not changing.

Here is my code:

select dateadd(dd,360,getdate())

Answer 1

You can use like this:

Select (Getdate()+360) As MyDate

There is no need to use the dateadd function for adding or subtracting days from the given date. For adding years, months, hours you require the dateadd function.

Want to know more about SQL? Join this SQL Course by Intellipaat.