Django query datetime for objects older than 5 hours

by

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”.

More Related Contents:

  1. How to filter empty or NULL names in a QuerySet?
  2. Custom QuerySet and Manager without breaking DRY?
  3. Why does django’s prefetch_related() only work with all() and not filter()?
  4. Select DISTINCT individual columns in django?
  5. Raw SQL queries in Django views
  6. How to limit queryset/the records to view in Django admin site?
  7. Django: implementing JOIN using Django ORM?
  8. Django – filtering on foreign key properties
  9. Django: Does prefetch_related() follow reverse relationship lookup?
  10. django most efficient way to count same field values in a query
  11. Django Order By Date, but have “None” at end?
  12. how to write a query to get find value in a json field in django
  13. How do I filter query objects by date range in Django?
  14. Django Aggregation: Summation of Multiplication of two fields
  15. Django: Populate user ID when saving a model
  16. Get model’s fields in Django
  17. Can django’s auth_user.username be varchar(75)? How could that be done?
  18. Django: Query using contains each value in a list
  19. How do you serialize a model instance in Django?
  20. How to make email field unique in model User from contrib.auth in Django
  21. Django ModelForm override widget
  22. Django unique_together with nullable ForeignKey
  23. How to dynamically provide lookup field name in Django query? [duplicate]
  24. Django lazy QuerySet and pagination
  25. Django: ManyToMany filter matching on ALL items in a list
  26. How to add a sortable count column to the Django admin of a model with a many-to-one relation?
  27. Password field in Django model
  28. Creating Partial Indexes with Django 1.7
  29. conversion of datetime Field to string in django queryset.values_list()
  30. Django Rest framework, how to include ‘__all__’ fields and a related field in ModelSerializer ?

Leave a Comment