select extract(year_month from campo_datetime) as mese_anno
from tabella
group by mese_anno