T-SQL Tutorial

How to add second to date T-SQL


Add second

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

Examples

select dateadd(S, 2, '2018-01-06 18:01:10.777');

select dateadd(SS, 3, '2018-01-06 18:01:10.777');

select dateadd(SECOND, 4, '2018-01-06 18:01:10.777');





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

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

select dateadd(SECOND, 3, current_timestamp);