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.

Reply via email to