Document caveats about using DateQuerySet in templates when time zone support is enabled.

[wiliamsouza83@…]

Improve the the warning in ​https://docs.djangoproject.com/en/dev/ref/models/querysets/#django.db.models.query.QuerySet.dates adding a example that when time zone settings.USE_TZ support is enabled and your time zone settings.TIME_ZONE is settled to America / Sao Paulo wich is UTC - 3 in BRT and UTC - 2 in BRST and DateQuerySet return "Oct. 10, 2012, midnight" you will get "Oct. 9, 2012, 9, 00, 00". You should turn off local time when displaying DateQuerySet to avoid problems:

{% load tz %}
{% localtime off %}
{% for month in date_list %}

<p>{{ month }}</p>

{% endfor %}
{% endlocaltime %}

[Aymeric Augustin]

I still plan to fix this at some point, see #17260.

[Aymeric Augustin]

Actually, your example still won't display the correct data, because the aggregation was performed in UTC and not in local time in the database.

Generally speaking, I don't want to document workarounds, I want to fix this bug.