How to add a time interval in given date in SQL Server?

Question

Aryan Kumar · Answer

To add a time interval in given date in SQL Server, you can use the DATEADD() function. The DATEADD() function takes four arguments:

The first argument is the datepart, which specifies the unit of time that you want to add. For example, you can use day, month, year, hour, minute, or second.
The second argument is the number of units of time that you want to add.
The third argument is the start date.
The fourth argument is the optional fourth argument is the end date.

The DATEADD() function returns the new date that is created by adding the specified time interval to the start date. For example, the following query will add 10 days to the date '2023-01-01':

SQL

SELECT DATEADD(day, 10, '2023-01-01');

This query will return the value '2023-01-11', which means that the new date is 10 days after the start date.

Here is the syntax for the DATEADD() function:

SQL

DATEADD ( datepart, number, start_date, end_date )

datepart is the datepart that you want to add.
number is the number of units of time that you want to add.
start_date is the start date.
end_date (optional) is the end date.

The DATEADD() function can also be used to add a time interval to a datetime. For example, the following query will add 3 hours to the datetime '2023-01-01 12:00:00':

SQL

SELECT DATEADD(hour, 3, '2023-01-01 12:00:00');

This query will return the value '2023-01-01 15:00:00', which means that the new datetime is 3 hours after the start datetime.

Ashutosh Kumar Verma · Answer

DATEADD(): SQL DATEADD() function is used to add a time in given date, like add a year, day or month etc. Example;

interview

How to add a time interval in given date in SQL Server?

Can you answer this question?

2 Answers