Mega Code Archive
Categories
/
MSSQL
/
Date Timezone
DATEADD(yy, -18, 4-29-1988 10
1> 2> -- 18 years before: 3> 4> SELECT DATEADD(yy, -18, '4-29-1988 10:30 AM') 5> GO ----------------------- 1970-04-29 10:30:00.000 (1 rows affected) 1>