4 Ways to Create Date Bins in Postgres: interval, date_trunc, extract, and to_char

Chris has lots of tips and sample code for getting date based report data from Postgres. He is rolling up days, weeks, months, and quarters and even has handy functions for labeling date results in your preferred format....