[Django] #33851: Bug: timestamp__day=day lookup gives incorrect results

[Django]

#33851: Bug: timestamp__day=day lookup gives incorrect results
-------------------------------------+-------------------------------------
Reporter: | Owner: nobody
omganeshdahale |
Type: Bug | Status: new
Component: Database | Version: 2.2
layer (models, ORM) |
Severity: Normal | Keywords: datetime day lookup
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
[[Image(https://imgur.com/a/4hzcvLz)]]

After experimenting more I found out datetime day lookup gives incorrect
results.
the queryset should not be empty, right?

--
Ticket URL: <https://code.djangoproject.com/ticket/33851>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#33851: Bug: timestamp__day=day lookup gives incorrect results
-------------------------------------+-------------------------------------

Reporter: omganeshdahale | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 2.2
(models, ORM) |
Severity: Normal | Resolution:

Keywords: datetime day lookup | Triage Stage:

| Unreviewed
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by omganeshdahale):

* Attachment "image.jpg" added.

[Django]

#33851: Bug: timestamp__day=day lookup gives incorrect results
-------------------------------------+-------------------------------------

Reporter: Om Dahale | Owner: nobody
Type: Bug | Status: closed

Component: Database layer | Version: 2.2
(models, ORM) |

Severity: Normal | Resolution: needsinfo

Keywords: datetime day lookup | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Tim Graham):

* status: new => closed
* resolution: => needsinfo

Comment:

Please use text to report the issue rather than an image. More details are
probably needed. What database are you using? Can you provide a small
sample project that includes a failing test case? Also, please test using
the latest release of Django rather than 2.2 which is unsupported. Reopen
the ticket when you provide more details. Thanks!

--
Ticket URL: <https://code.djangoproject.com/ticket/33851#comment:1>