CODEWITHSUNDEEP
pythondjango
Hp740319
Hp740319

Reputation: 747

Get object with specific hour in django

I have model like this:

class Order(models.Model):
    dateTime = models.DateTimeField()

and I want to get object with specific hour how can I do that? the code below doesn't work:

o=Order.objects.get(dateTime.hour=12)

and has this problem: keyword can't be an expression

now.. How should I give the order object with specific time?

Upvotes: 0

Views: 911

Answers (2)

Ankush Raghuvanshi
Ankush Raghuvanshi

Reputation: 1442

The following will give you all the objects having hour value as 12.

o = Order.objects.filter(dateTime__hour=12)

which can be used in place of 

o = Order.objects.get(dateTime__hour=12)`

to get that one object, in case you have unique hour values for objects.

But if already know that you have unique value of hour then you should use the later.

Upvotes: 1

mechanical_meat
mechanical_meat

Reputation: 169304

https://docs.djangoproject.com/en/1.9/ref/models/querysets/#hour

o = Order.objects.filter(dateTime__hour=12)

Upvotes: 0

Related Questions