Changes between Initial Version and Version 1 of Ticket #29384, comment 3


Ignore:
Timestamp:
05/08/18 02:33:19 (4 years ago)
Author:
Fossen
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #29384, comment 3

    initial v1  
    99But I still don't think it's a good idea to convert utc time to local time in database when querying.
    1010Django 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
    11  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.
     11convert 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.
Back to Top