Opened 14 years ago
Closed 14 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.