On Mon, Oct 6, 2008 at 6:36 PM, Kasper Grubbe <[EMAIL PROTECTED]> wrote:
> I have a date in my database. And i want to list all years and months
> in that, without duplicates.
> I can get the data out without duplicates with this SQL query:
> SELECT DATE_FORMAT(my_date_field, '%Y %m') AS year_month FROM mytable
> GROUP BY year_month
You could perhaps get the select stuff you wanted like this:
Entry.objects.extra(select={'year_month': "DATE_FORMAT(my_date_field,
'%Y %m')"})
However, last I checked, there's really nothing to replicate GROUP BY
functionality in the ORM. A quick search of the documentation seems to
reinforce that. I'd love to know if that's no longer correct.
I think dropping to raw SQL may be the only option here.
/alex
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
