Date Functions MSSQL Tutorial

3>  SELECT DATEPART(dd, '7/5/99')
4> GO
-----------
          7
(1 rows affected)