Text copied!
DATEADD function
In SQL, DATEADD function is used to add or subtract specific 'date/time interval' to a date or time.
The syntax of the DATEADD function generally looks like this :
DATEADD(datepart, number, date )
• Specify the 'datepart' that indicates the specific portion of the date or time to which the numeric value should be added. i.e. second, minutes, hour, day, week, month, year, etc.
• Specify the 'number' of 'datepart intervals' that you want to to add or subtract.
• Specify the 'date' or 'datetime' value to which the interval is added or subtracted.
Here's an example of how you might use the DATEADD function :
1. Let's assume we have a table named "[Employees]".
2. Let's assume you want to add 10 years to the Joining_Date column for each employee.
3. Run below SQL statement :
SELECT *, DATEADD(YEAR, 10, Joining_Date) AS Revised_Joining_Date
FROM [Employees];
4. In above statement, DATEADD function adds 10 years to the Joining_Date column for each employee and returns result in a column named 'Revised_Joining_Date'.
Remember :
Using this function in a select statement won't modify the [Employees] table directly, but it will only be reflected in the select statement's output.