Hi, Kasper Grubbe wrote: > Hi guys. > > I have a date in my database. And i want to list all years and months > in that, without duplicates. For an example i want to print out (only > if they exists in the database): > > 2008: > January > August > December > > 2007: > September > December > > 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 > > This will give me a couple of rows which i will work on in python to > get it to work for my solution. Is there an easier way? And can i get > rid of the SQL and use "pure" django models? > > Have a look at: http://docs.djangoproject.com/en/dev/ref/models/querysets/#dates-field-kind-order-asc
adi --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
