Home › SQL Server

Adding Dates


Adding 1 YEAR to a DATETIME value

DECLARE @d DATETIME
SELECT @d = '2009-03-14 10:00:00'
SELECT DATEADD(year, 1, @d) AS date
/*
date
-----------------------
2010-03-14 10:00:00.000
*/

Documentation

Adding 1 Quarter to a DATETIME value

DECLARE @d DATETIME
SELECT @d = '2009-03-14 10:00:00'
SELECT DATEADD(quarter, 1, @d) AS date
/*
date
-----------------------
2009-06-14 10:00:00.000
*/

Documentation

Adding 3 Months to a DATETIME value

DECLARE @d DATETIME
SELECT @d = '2009-03-14 10:00:00'
SELECT DATEADD(month, 3, @d) AS date
/*
date
-----------------------
2009-06-14 10:00:00.000
*/

Documentation

Adding 1 WEEK to a DATETIME value

DECLARE @d DATETIME
SELECT @d = '2009-03-14 10:00:00'
SELECT DATEADD(week, 1, @d) AS date
/*
date
-----------------------
2009-03-21 10:00:00.000
*/

Documentation

Adding 5 Days to a DATETIME value

DECLARE @d DATETIME
SELECT @d = '2009-03-14 10:00:00'
SELECT DATEADD(day, 5, @d) AS date
/*
date
-----------------------
2009-03-19 10:00:00.000
*/

Documentation

Adding 6 Hours to a DATETIME value

DECLARE @d DATETIME
SELECT @d = '2009-03-14 10:00:00'
SELECT DATEADD(hour, 6, @d) AS date
/*
date
-----------------------
2009-03-14 16:00:00.000
*/

Documentation

Adding 15 Minutes to a DATETIME value

DECLARE @d DATETIME
SELECT @d = '2009-03-14 10:00:00'
SELECT DATEADD(minute, 15, @d) AS date
/*
date
-----------------------
2009-03-14 10:15:00.000
*/

Documentation

Adding 30 Seconds to a DATETIME value

DECLARE @d DATETIME
SELECT @d = '2009-03-14 10:00:00'
SELECT DATEADD(second, 30, @d) AS date
/*
date
-----------------------
2009-03-14 10:00:30.000
*/

Documentation

Adding 100 Milliseconds to a DATETIME value

DDECLARE @d DATETIME
SELECT @d = '2009-03-14 10:00:00'
SELECT DATEADD(millisecond, 100, @d) AS date
/*
date
-----------------------
2009-03-14 10:00:00.100
*/

Documentation

Share |
 Cant find the page you are looking for?
 Help us to improve by adding the content that you are looking for.
 Leave a feedback
 We look forward to hear your comments and feedback.
  • 1185 reads