How to add 30 days to a date in SQL Server

CoderGirl

Edited On 9 MARCH 2022

Category: SQL

1 Answers
722 Views
1 Likes

I have a Table which shows Course details, in which I have column named "start_date" which tells when the course was started and another column named "course_duration" which shows number of days of this course. So based on the 2 columns, I want to calculate the end_date of the course (i.e. end_date=start_date+30days). How do I achieve that using a select query in SQL Server?

1 Replies

Answer Now

Shaddy

You can use SQL Server's DATEADD() function to add any number of days to your SQL date object. I created a sample SQL Query for your reference, here END_DATE will be START_DATE+30 days.

select Course_ID, START_DATE, DATEADD(day,30,START_DATE) END_DATE
from Course_Details
where Course_ID in(1, 10, 20);

Published on 9 MARCH 2022 at 1:38

0 Likes Reply

Have any programming Errors?

Ask Us

Ask Question

Users Leaderboard

Shaddy
Ajay
CoderGirl
BroCode
AI_Code

Online Tools

Case Converter
Reverse String
Word Counter
Remove Duplicate Lines
Remove Empty Lines
Remove Spaces
Python IDE Online
Java IDE Online