Time zone problem

Hello, I haven’t solved my problem after reading the related problems on the forum.

mysql version :
mysql> select version();
±------------------------+
| version() |
±------------------------+
| 5.7.27-0ubuntu0.16.04.1 |
±------------------------+
1 row in set (0.04 sec)

metabase version:
v0.32.8

Log information when starting Metabase:
11-12 17:43:02 INFO metabase.core :: System timezone is ‘Asia/Shanghai’ …

mysql time-zone:
mysql> show variables like ‘%time_zone%’;
±-----------------±--------------+
| Variable_name | Value |
±-----------------±--------------+
| system_time_zone | CST |
| time_zone | Asia/Shanghai |
±-----------------±--------------+

Some data information in MySQL table:


We can see that the date is from March 1, 2019

Some data information in Metabase:

But when I aggregate by week, we get the following information:

We can see that it started in February 2019, but the data in my MySQL started in March 2019. What are the reasons for this result? How can I get the data in metabase from March 2019

Hi @zsk
I don’t understand the problem. I cannot read Chinese, so I don’t know what months you are displaying.
Since the week of March 1st is number 9 and is the following period Feb 24, 2019 – Mar 2, 2019, then could that be the reason for your problem?
There were an issue, which focused on making it more clear, but it’s a tricky subject:
https://github.com/metabase/metabase/issues/6862