Tente usar o extract:

SELECT 
    EXTRACT(YEAR FROM date_column) as YEAR,
    EXTRACT(MONTH FROM date_column) AS MONTH
FROM TABLE