Opened 13 years ago
Closed 13 years ago
#18049 closed New feature (duplicate)
time lookup missng
Reported by: | Owned by: | nobody | |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | dev |
Severity: | Normal | Keywords: | time lookup |
Cc: | Triage Stage: | Unreviewed | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
there is day, month, year lookup ,but time lookup is missing
Example of use:
# lets search for events that start after 2 PM Event.objects.filter(start__time__gte=datetime.now())
SQL equivalent:
SELECT ... WHERE EXTRACT('time' FROM pub_date) >= '14:00:00';
Note:
Splitting datetime fields into two date & time fields sometimes makes no sense, and makes other stuff harder
Note:
See TracTickets
for help on using tickets.
Duplicate of #8424.