How Use Django ORM to query only by time in a datetimefield

Question

I have a datetimefield: 2013-03-14 17:30:21
I want to query ONLY by the time, ignoring the date.

Like this:

list = MyModel.filter(dateTimeField_time_gte = '09:00:00', dateTimeField_time_lte = '10:00:00')

but it doesn't work.

I need to filter only by time, ignoring the date. – brunozrk Mar 14 '13 at 18:59 — brunozrk, Mar 14 '13 at 18:59
Have you found any solution on that? – Nikhil Bhardwaj Jan 18 '21 at 11:11 — Nikhil Bhardwaj, Jan 18 '21 at 11:11

score 0 · Answer 1 · edited May 23 '17 at 12:21

0

See this Stack Overflow question for some insights on how to filter by a date or time range: Django model timerange filtering method

edited May 23 '17 at 12:21

Community

answered Mar 14 '13 at 18:27

Brandon Taylor

I need to filter only time, ignoring date – brunozrk Mar 14 '13 at 18:41
1

This question explain how to query by date, by date and time, but not for time ONLY – brunozrk Mar 14 '13 at 20:38

1 Answers1