CODEWITHSUNDEEP
pythondjangodjango-modelsormmodel
Waleed Khan
Waleed Khan

Reputation: 93

Django model created DateTimeField & now difference

I need data from MYSQL table using Django model ORM.

How can I get Query Set having data filtered on the bases of difference for created(DateTimeField) and now.

Here created is table column and now is MYSQL NOW();

My Use Case is to get rows those were created 7 days OR 168 hours ago.

Upvotes: 0

Views: 394

Answers (1)

Ersain
Ersain

Reputation: 1520

Here created__lte searches for rows where created is less than or equal to a given date

from datetime import datetime, timedelta

...

CourseEnrollment.objects.filter(created__lte=(datetime.now() - timedelta(days=7)))

Upvotes: 1

Related Questions