xxxxxxxxxx
SELECT * FROM your_table
WHERE YEAR(date_column) = YEAR(CURRENT_DATE)
AND MONTH(date_column) = MONTH(CURRENT_DATE);
xxxxxxxxxx
-- Oracle
SELECT extract(YEAR FROM sysdate) FROM dual; // number
SELECT to_char(sysdate, 'YYYY') FROM dual; // varchar