Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

Find the number of days between 24th March 2001 and 24th March 1964

1> -- Find the number of days between 24th March 2001 and 24th March 1964 using 2> 3> SELECT DATEDIFF(dd, "24 March 2001","24 March 1964") 4> GO -----------      -13514 (1 rows affected) 1>