Answers for "sql server add a day to a date"

SQL
1

sql add days to date

//Returns Date time
//Takes where to add (as in year, month, day, etc) to
//Takes how much to add
//Takes a datetime in some different formats
DATEADD(day, 1, '2017/08/25')
Posted by: Guest on March-23-2021
0

sql server add time to date

DECLARE @date DATETIME
SET @date='2010-10-01'
SET @date=@date+'15:00:00'
SELECT @date AS DATETIME
Posted by: Guest on May-18-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language