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);