By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @shift_start_time DATETIME = '2015-11-01 08:00:00.000';
DECLARE @increase INT = 30;
SELECT DATEADD(mi, @increase, @shift_start_time)
(No column name) |
---|
2015-11-01 08:30:00.000 |