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!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
