group by month and year pgsql code example Example: postgresql group by month and year date_trunc('month', col_date)