Opened 5 years ago

Closed 5 years ago

#31860 closed Bug (duplicate)

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

Reported by: Aleksandr Smechov Owned by: nobody
Component: Database layer (models, ORM) Version: 3.1
Severity: Normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by 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.

Change History (4)

comment:1 by Aleksandr Smechov, 5 years ago

Description: modified (diff)

comment:2 by Aleksandr Smechov, 5 years ago

Description: modified (diff)

comment:3 by Aleksandr Smechov, 5 years ago

Description: modified (diff)

comment:4 by Carlton Gibson, 5 years ago

Resolution: → duplicate
Status: new → closed

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

Note: See TracTickets for help on using tickets.
Back to Top