Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

SELECT DATEADD(dayofyear, 18, 4-29-1988 10

9> 10> 11> SELECT DATEADD(dayofyear, 18, '4-29-1988 10:30 AM') 12> GO ----------------------- 1989-10-29 10:30:00.000 (1 rows affected) ----------------------- 1988-05-17 10:30:00.000 (1 rows affected)