,date_trunc('month',date)::date as first_day_of_month ,(date_trunc('month',date) + interval '1 month' - interval '1 day')::date as last_day_of_month ...