The syntax of DATEADD() goes like this: DATEADD (datepart, number, date ) This article contains examples to demonstrate. For example, you could take ‘’, add 10 years, then return the (increased) year component.
You can also combine DATEADD() with other functions to format the date as required.
You can also use it to subtract a specified time period. In SQL Server, you can use the DATEADD() function to add a specified time period to a given date.