Mega Code Archive
Categories
/
MSSQL Tutorial
/
Date Functions
Select DATEADD(second, 1, 2002-09-30 11
2> 3> select DATEADD(second, 1, '2002-09-30 11:35:00') 4> GO ----------------------- 2002-09-30 11:35:01.000 (1 rows affected)