In order to get addition of interval in a date, you have to use DATEADD in a function. SQL Server can carry out this function.
The procedure of the function DATEADD is given below;
The data type related to expression can be in the form of time, datetime or date. Here, number is used. It can be negative or positive. We can use the following
ISO_WEEK isowk, isoww
year yy, yyyy
quarter qq, q
month mm, m
dayofyear dy, y
day dd, d
week wk, ww
minute mi, n
second ss, s
The product has similar data type.
Here is an example of SQL statement for better explanation;
The product will be like this;