Getting only Month and Year from SQL DATE

Question

I want to access only Month.Year from Date field in SQL Server.

Answer 1

In addition to the advice already given, I can deduce the following possibility from your question:
- You still want the result to be a date.
- But you want to 'discard' the Days, Hours, etc
- Leaving a year/month only date field.

SELECT
   DATEADD(MONTH, DATEDIFF(MONTH, 0, <dateField>), 0) AS [year_month_date_field]
FROM
   <your_table>

This subtracts the amount of partial months from a base date (zero) and then adds them. Rounding down to the month that the date is in does as a result.

I hope this helps you.