W.K W.K - 5 months ago 41
SQL Question

SQL add one day to start date

I have the following

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.


With the DATEADD function:

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

MSDN reference: