Django objects queryset filter by matching datetime

Question

I have a model with a field name 'timestamp' that is a datetime field, and when I print them in python manage.py shell I get:

>>> a.timestamp
datetime.datetime(2013, 7, 15, 18, 45, tzinfo=<UTC>)

Now.... I am running django celery task every 30 seconds that suppose to retrieve all the matching objects in the last 30 seconds.

how can I do it (thing = MyModelName.objects.filter(.. something ..)

I hope that I manage to explain my self.

Thank you all in advanced.

Update: When I am typing in my server (python shell)

datetime.datetime.now() I am getting

datetime.datetime(2013, 7, 15, 20, 34, 4, 366166)

Just updated my question. The problem that I am having is that I am not getting the matching objects. maybe it has something to do with timezone? — yaniv14
– yaniv14, Commented Jul 15, 2013 at 20:35

Peter DeGlopper · Accepted Answer · 2013-07-15 19:46:25Z

2

MyModelName.objects.filter(timestamp__gte=(datetime.datetime.now() - datetime.timedelta(seconds=30)))

answered Jul 15, 2013 at 19:46

Peter DeGlopper

37.5k7 gold badges95 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

yaniv14 Over a year ago

With your code I am getting all the object every 30 seconds, which is not good. :( Thank you very much for your help

Peter DeGlopper Over a year ago

That shouldn't be the case - but you could try django.utils.timezone.now() instead of datetime.datetime.now(). docs.djangoproject.com/en/dev/ref/utils/…

Kousik · Accepted Answer · 2013-07-15 19:49:29Z

1

import datetime
from datetime import timedelta

time = datetime.datetime.now()
delta = timedelta(seconds=30)
newtime = time + delta #after adding 30 sec with current time

so you can loop through the (newtime - time) time interval then  you can
get the expected result.

answered Jul 15, 2013 at 19:49

Kousik

22.6k7 gold badges39 silver badges60 bronze badges

Collectives™ on Stack Overflow

Django objects queryset filter by matching datetime

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related