You should be able to use the YEAR and MONTH functions in SQL to create separate columns for year and month, something like this:

SELECT DISTINCT

YEAR(date_column) as YEAR,

MONTH(date_column) as Month

FROM

TABLE