I am using a little raw SQL to pull out a count of events by month. I
am able to retrieve the correct information but am getting the month
value in numerical form rather than an actual name. So instead of
January I get a 1.
Here is query:
dates = markers.extra(select={'month':
'month(date)'}).values('month').order_by('month').annotate(month_count=Count('id'))
originally I had something like this:
dates = markers.extra(select={'month':"strftime('%F',
'month(date)')"}).values('month').order_by('month').annotate(month_count=Count('id'))
but that was returning 0 results
any help would be much appreciated.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
