Question - How do I retrieve only the date or time portion of the data?
Answer -
You can use T-SQL's DATEPART() function to return a subset of the values that SQL Server's datetime columns store. The DATEPART() function uses two arguments. The first argument specifies the portion of the date that you want, and the second value specifies the datetime column:
SELECT orderID, DATEPART(MM,OrderDate) AS OrderMonth FROM Orders