If the value for date is a string literal date, DATEADD returns a datetime value. If another valid input data type is supplied for date, DATEADD returns the same data type.

Aug 25, 2017 · Definition and Usage The DATEADD () function adds a time/date interval to a date and then returns the date. Syntax DATEADD (interval, number, date)

Jan 7, 2022 · The DATEADD function returns a date with the addition of a specified part of the date. For example, if you add one year to the current date, it will return the date provided plus 1 year.

This tutorial shows you how to use the SQL DATEADD function to add an interval to a date or subtract an interval from a date.

In SQL Server (Transact-SQL), the DATEADD function returns a date after which a certain time/date interval has been added.

In SQL Server, the DATEADD () function adds a number to a datepart and returns the modified datetime value.

Mar 5, 2026 · The DATEADD function in SQL adds a time/date interval to a date and then returns the date. This allows you to add or subtract a certain period of time from a given start date.

This article explores the DATEADD SQL function and its usage scenarios with various examples.

Jun 10, 2024 · The DATEADD function in SQL Server is used to add or subtract specified units (such as days, months, years) to a given date, providing the resulting date or time.

Jan 2, 2025 · Adding and subtracting dates is often needed to compare time frames and in this article we look at how to do this with DATEADD in SQL Server.