I am displaying a time series data in both a graph and table.
The graph shows the right date, the table shows UTC time.
DB is MySQL
I have tried changing timezone in Configuration > Preferences but all options give the same results.
For the graph I am selecting the column with UNIX_TIMESTAMP(created)
If I do the same with the Table I get the right time but 1970 as the year and wrong month too.
I am now just selecting “created” without sql transformation (this is a mysql datetime column) and it return the wrong time in the table but the graph axis is ok.
Any idea how to solve this.
Mysql globale locale is set to AWST (UTC +8)
Thanks
Nic