Electronics & Programming

develissimo

Open Source electronics development and programming

  • You are not logged in.

#1 Dec. 29, 2010 15:45:45

N.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

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

Offline

Board footer

Moderator control

Enjoy the 12th of December
PoweredBy

The Forums are managed by develissimo stuff members, if you find any issues or misplaced content please help us to fix it. Thank you! Tell us via Contact Options
Leave a Message
Welcome to Develissimo Live Support