dates(field, kind, order='ASC')
Returns a QuerySet that evaluates to a list of datetime.date objects representing all available dates of a particular kind within the contents of the QuerySet.
field should be the name of a DateField of your model. kind should be either "year", "month" or "day". Each datetime.date object in the result list is “truncated” to the given type.
-
"year"returns a list of all distinct year values for the field. -
"month"returns a list of all distinct year/month values for the field. -
"day"returns a list of all distinct year/month/day values for the field.
order, which defaults to 'ASC', should be either 'ASC' or 'DESC'. This specifies how to order the results.
Examples:
1 2 3 4 5 6 7 8 9 10 | >>> Entry.objects.dates('pub_date', 'year')[datetime.date(2005, 1, 1)]>>> Entry.objects.dates('pub_date', 'month')[datetime.date(2005, 2, 1), datetime.date(2005, 3, 1)]>>> Entry.objects.dates('pub_date', 'day')[datetime.date(2005, 2, 20), datetime.date(2005, 3, 20)]>>> Entry.objects.dates('pub_date', 'day', order='DESC')[datetime.date(2005, 3, 20), datetime.date(2005, 2, 20)]>>> Entry.objects.filter(headline__contains='Lennon').dates('pub_date', 'day')[datetime.date(2005, 3, 20)] |
Please login to continue.