interview

Home / DeveloperSection / Interviews / How to add a time interval in given date in SQL Server?

Ask Question
Ashutosh Kumar Verma

Ashutosh Kumar Verma

Follow
Myself Ashutosh Kumar Verma from Varanasi. I am a Software Developer in MindStick Software pvt. ltd. Prayagraj. I have completed my MCA from VBSP. University, Jaunpur in 2021.

Can you answer this question?

Answer

1 Answers

Ashutosh Kumar Verma

Ashutosh Kumar Verma

21-Nov-2021

DATEADD():

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

Example;

SELECT DATEADD(DAY,1,'2020/12/10');
Output :    2020-12-11 00:00:00.000
SELECT DATEADD(MONTH,1,'2020/12/10');
Output:    2021-01-10 00:00:00.000

SELECT DATEADD(YEAR,1,'2020/12/10'); 
Output:     2021-12-10 00:00:00.000

advertising

Liked By