Django query datetime for objects older than 5 hours

Question

I'm trying to write a Django query for widgets that are more than 5 hours old and I'm a bit lost. The widget model has a DateTimeField that is populated with the creation time of the widget.

Answer 1

If Widget is the name of your model, and it has a DateTimeField attribute named created, the query would be:

from datetime import datetime, timedelta  time_threshold = datetime.now() - timedelta(hours=5) results = Widget.objects.filter(created__lt=time_threshold) 

Note that created__lt means "created is less than".

Answer 2

now = datetime.datetime.now() earlier = now - datetime.timedelta(hours=5) MyModel.objects.filter(my_date_field__range=(earlier,now)) 

That should do the trick.