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 the result :

2015-11-01 08:30:00.000

Answer 1

Use DATEADD:

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

db<>fiddle demo