Mega Code Archive
Categories
/
MSSQL
/
Date Timezone
SELECT DATEADD(hh,12,24 March 1964)
1> -- Add 12 hours to 24th March 1964 2> 3> SELECT DATEADD(hh,12,"24 March 1964") 4> 5> GO ----------------------- 1964-03-24 12:00:00.000 (1 rows affected) 1>