#29384: Change the SQL while filtering by month or day with MySQL when USE_TZ is
True
-------------------------------------+-------------------------------------
Reporter: Fossen | Owner: nobody
Type: | Status: closed
Cleanup/optimization |
Component: Database layer | Version: 2.0
(models, ORM) |
Severity: Normal | Resolution: invalid
Keywords: MySQL | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Fossen):
Replying to [comment:2 Aymeric Augustin]:
> This suggestion won't work in timezones that have DST. Most time zones
do.
>
> (Besides there's a number of other reasons why it was decided in #2626
to store datetimes in UTC in the database rather than in local time.)
Thanks for your reply
I haven't thought about DST, and I also find there are some situations
that I didn't consider. I will think about it.
But I still don't think it's a good idea to convert utc time to local time
in database when querying.
Django saves utc time to database,and database won't deal with timezone.
But, actually, when querying datetime with filtering by month or day in
MySQL, it need MySQL to
convert utc time (raw data) to local time (filtering condition), and then
select the matching data. This process depends on the time zone tables
which stores in database, rather than pytz. I think the timezone
convertions should be handled by pytz both when saving and querying.
--
Ticket URL: <https://code.djangoproject.com/ticket/29384#comment:3>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/068.5f2a59bf73beed81033dbbafa1e65962%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
