I would like to do aggregate calculations based on month for a datetime field.
I am currently using the extra() function to format the date like:
...extra(select="strftime('column', '%m/%Y') as t").values('t').annotate(SUM(foo))
and it works great for sqlite3.
In sqlite3 I can use strftime(), but that doesn't work with MySQL. In MySQL I can use date_format(), but that doesn't work with sqlite3.
How can I rewrite this to work for both database types?
Most of the developers simply use sqlite3 on their dev machines, and MySQL is used on the prod server.
Thanks!