select convert(char(4),year(getdate())) + convert(char(4),month(getdate()))
SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, <dateField>), 0) AS [year_month_date_field] FROM <your_table>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)