SQL add one day to start date

Question

I have the following select statement that display the start date to end date information. I would like to add one day to the "start date". That means instead of 27/10/2016. It will be come 28/10/2016.

CONCAT(FORMAT(sc.StartDate,'dd/MM/yyy'), + ' - ' + FORMAT(sc.ENDDate,'dd/MM/yyy')) SIPDate

I'm using SQL server 2014.

Refer this http://stackoverflow.com/questions/167491/sql-server-2005-using-dateadd-to-add-a-day-to-a-date — soumyakmurthy, Oct 27 '16 at 03:28
Look at dateadd. https://msdn.microsoft.com/library/ms186819.aspx — Doon, Oct 27 '16 at 03:29

score 1 · Accepted Answer · answered Oct 27 '16 at 03:28

1

With the DATEADD function:

CONCAT(FORMAT(DATEADD(dd,1,sc.StartDate),'dd/MM/yyy'), + ' - ' + FORMAT(sc.ENDDate,'dd/MM/yyy')) SIPDate

MSDN reference:

https://msdn.microsoft.com/en-us/library/ms186819.aspx

answered Oct 27 '16 at 03:28

John Smith

7,243
6
49
61

score 1 · Answer 2 · edited Oct 27 '16 at 03:31

1

You can use DATEADD() function. Example:

DATEADD(day,1,StartDate)

edited Oct 27 '16 at 03:31

John Smith

7,243
6
49
61

answered Oct 27 '16 at 03:29

Rafat Ahmad

169
1
10

score 1 · Answer 3 · answered Oct 27 '16 at 03:30

1

Use Dateadd

Dateadd(dd,1,Startdate) as Startdate

answered Oct 27 '16 at 03:30

Jacky Montevirgen

307
2
14

score 0 · Answer 4 · answered Oct 27 '16 at 06:34

you can use GETDATE() Also

if your start date is today:

select DATEADD(day,1,GETDATE())

 select convert (varchar, dateadd(DAY,1,getdate()),103)

For specific date use this:

  declare @date as date ='20161027'
  select convert (varchar, dateadd(DAY,+1,@date),103)

SQL add one day to start date

4 Answers4