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:
>>> 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.