Below will be the output:-
As we can see in the output,Time is Same but Date is Different as 04 December and 19 December.
So, DateAdd as the name implies,adds date to the supplied date.
DateAdd is an in-built Sql-Server function.
Here,DD means day which is a datepart.
Asked In: Many Interviews |