sqlsql-serverdatetimetimedateadd

How to add minutes to the time part of datetime

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
Solution

  • Use DATEADD:

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

    db<>fiddle demo