"__date" in F expression not working, have to use Func()

[Aleksandr Smechov]

When filtering a query for two equal datetime fields (both being timestamps), and using __date, the __date in the F expression remains a timestamp.

For example:

Author.objects.filter(
    Q(articles__isnull=False) 
    & Q(articles__date_published__date=F("articles__date_edited__date"))
)

This will return an empty set, as F("articles__date_edited__date") remains a timestamp. I instead have to revert to using Func.

Author.objects.annotate(
    date_edited=Func(F("articles__date_edited"), function="DATE"))
    .filter(Q(articles__isnull=False) & Q(articles__date_published__date=F("date_edited"))
)

The above works. Not sure if relevant, but in settings I have USE_TZ enabled.

[Carlton Gibson]

Hi. I believe this is a duplicate of #31639.