string format date in query

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-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.