Opened 3 years ago
Closed 3 years ago
#32722 closed Bug (fixed)
Comparing to TruncTime() doesn't work on Oracle.
| Reported by: | Mariusz Felisiak | Owned by: | Mariusz Felisiak |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | 3.2 |
| Severity: | Normal | Keywords: | oracle ttrunctime |
| Cc: | Simon Charette | Triage Stage: | Ready for checkin |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
Comparing to TruncTime() doesn't work on Oracle because we don't change the date part to 1900-01-01 (which is set for TimeFields), e.g.
.filter(start_datetime__time=start_datetime.time())
is translated to
"DB_FUNCTIONS_DTMODEL"."START_DATETIME" = 1900-01-01 14:30:26.000321
which cannot work because start_datetime == datetime(2015, 6, 15, 14, 30, 26, 321).
Noticed when checking #32699.
Change History (3)
comment:1 by , 3 years ago
| Has patch: | set |
|---|
comment:2 by , 3 years ago
| Triage Stage: | Unreviewed → Ready for checkin |
|---|
Note:
See TracTickets
for help on using tickets.
PR