Comparing two fields in django queryset

Question

How would I do the following SQL query in the Django ORM?

SELECT * FROM my_table WHERE date_added > date_created;

Answer 1

I'm guessing you don't have the date_created available as a variable (as @tttthomasssss assumes) so it will be something like this:

from django.db import models

YourTable.objects.filter(date_added__gt=models.F('date_created')

Docs on F expressions: https://docs.djangoproject.com/en/dev/ref/models/expressions/#f-expressions