[Django]-Problems filtering django datetime field by month and day

I was seeing exactly the same behaviour as you.

If you check the documentation for 1.6 and the month queryset. They have added the following paragraph:

“When USE_TZ is True, datetime fields are converted to the current time zone before filtering. This requires time zone definitions in the database.”

If you change the following line in your settings to False, then you should start getting the data back that you’re expecting.

USE_TZ = False

Your syntax is incorrect. It should be:

Clicks.objects.filter(created__month=2)

(you left off the ‘objects’ manager)

To update the answer here since I ran into the above issue but none of the solutions worked. Most new mysql installations come pre-installed with tz-info, so the mysql_tzinfo_to_sql command wont really help. And setting TZ_INFO to False isn’t really a solution since many need time-zone aware datetime.

So, what worked for me was to create a tz aware datetime object and check against that. Lets say you wanna filter records for today you would do something like,

from datetime import datetime
import pytz

today = datetime.now().replace(tzinfo=pytz.UTC).date()   # tz aware datetime object
todays_records = myModel.objects.filter(created__year=today.year, created__month=today.month,created__day=today.day)

Hope this helps.

Solution for windows, 2022 – how to make django with USE_TZ=True be able to filter by month and day, not just year. Example of now working code: queryset.filter(created__month=1)

• download the timezone file from here: https://dev.mysql.com/downloads/timezones.html
• make sure you get the right one – for mysql8 I used the file for 5.7
• unzip it – see that it’s just a sql file
• load it into your mysql database. something like

mysql -u root -p mysql < FILEPATH

• restart mysql service (control panel | administration tools | services | find mysql | restart)
• validation: mysql | use mysql | select * from time_zone
• you should see a few thousand entries. If not, it means you didn’t load the sql file in correctly.
• rerun django methods using filtering and it should work.

Note: this is different than varnothing‘s answer above because on windows, dealing with filetypes or things like mysql_tzinfo_to_sql may be different due to pathing. This one works because you fall back to clear actions like "load this sql file into this db"