Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class Foo(models.Model):
- start = models.DateTimeField()
- end = models.DateTimeField()
- from django.db.models import F
- Foo.objects.filter(start__year=F('end__year'))
- SELECT "foo"."id", "foo"."start", "foo"."end" FROM "foo" WHERE django_datetime_extract('year', "foo"."start", 'UTC') = ("foo"."end")
- from django.db.models import F
- from django.db.models.functions import ExtractYear
- Foo.objects.annotate(start_year=ExtractYear(F('start'))).filter(end__year=F('start_year'))
- SELECT "foo"."id", "foo"."start", "foo"."end", django_datetime_extract('year', "foo"."start", 'UTC') AS "start_year" FROM "foo" WHERE django_datetime_extract('year', "foo"."end", 'UTC') = (django_datetime_extract('year', "foo"."start", 'UTC'))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement