How to add minutes to the time part of datetime

Question

How to add minutes(INT) to the time part of datetime ?

For example :

If I have datetime variable like this :

  @shift_start_time =  2015-11-01 08:00:00.000

  @increase = 30

How to get this result?

2015-11-01 08:30:00.000

Lukasz Szozda · Accepted Answer · 2019-10-07T14:29:32.500

71

SELECT DATEADD(mi, @increase,   @shift_start_time);

edited Oct 07 '19 at 14:29

answered Nov 17 '15 at 15:20

Lukasz Szozda

score 18 · Answer 2 · edited Sep 23 '22 at 15:31

18

Using dateadd:

DATEADD(minute,@increase,@shift_start_time)

the first argument can be chosen among: year quarter month dayofyear day week weekday hour minute second millisecond microsecond nanosecond

edited Sep 23 '22 at 15:31

kashlo

answered Nov 17 '15 at 15:21

Simone

score 1 · Answer 3 · edited Jul 26 '19 at 00:41

1

To add minutes to the time part of datetime =>

SELECT DATEADD("mi", @increase,   @shift_start_time);

edited Jul 26 '19 at 00:41

G_real

answered Jul 25 '19 at 19:16

Aditya Prabhu

How does this differ from or add to the already accepted answer? – phalteman Jul 25 '19 at 19:54
Explicitly stating that the first argument is a string. – Aditya Prabhu Jul 26 '19 at 17:40

3 Answers3