I’m using a grid view to display a date stored into the database with timezone set to Europe/Rome. When the grid is displayed, you can see the time two hours forward than the time stored into the database. As example, I have a row into the database with time 23/08/2015 16:44:23. The grid shows 23/08/2015 18:44:23. I set up the format of the column as ‘format’ => [‘date’, ‘php:d-m-Y H:i’], but nothing change if I remove the format option to the grid. The only way to display the date correctly is to create a new query using db\Query object and in select statement specify the mysql DATE_FORMAT function in this way: DATE_FORMAT(q_template.datains,‘d/m/Y H:i:s’).
Could you help me to understand why the grid view won’t show the right values?