News for hackers. Stuff that matters.
Re:PostgreSQL's Missing DateDiff Function by ants_a on Wednesday December 22, 2021 @09:08AM (#29649454)
In PostgreSQL you would group by date_trunc('month', transaction_date)
Re:PostgreSQL's Missing DateDiff Function by function_seven on Wednesday December 22, 2021 @12:34PM (#29652472)
That would produce dates instead of integers though. I want a table that looks like this:

    MonthsAgo | Sales
    ==================
            4 | 4,500
            3 | 7,204
            2 | 12,578
            1 | 15,748
            0 | 34,485
And maybe use a parameter so the user can go by week, or quarter, or whatever.