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)
[ Parent
| on HN ]
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.