T-SQL Tutorial

How to add minute to date T-SQL


Add minute

How to add minute to date DATEADD function with getdate, sysdatetime, current_timestamp.

Examples

select dateadd(MI, 3, '2018-01-06 18:08:43.777');

select dateadd(MINUTE, 5, '2018-01-06 18:08:43.777');





select dateadd(MINUTE, 1, getdate());

select dateadd(MINUTE, 2, sysdatetime());

select dateadd(MINUTE, 3, current_timestamp);