gistfile1.sql

select distinct extract(month from created_at)||' '||extract(year from created_at), extract(month from created_at), extract(year from created_at) from articles


MYSQL:

select distinct concat(month(created_at),' ',extract(year from created_at)) as date, month(created_at) as month, year(created_at) as year from articles