The sql 'set time_zone' ensures that all dates retrieved are in UTC time. If your MySql server has the time zone names installed then use 'UTC' instead of '+00:00'.
Components
Copy the code at the end of this wiki for LocalTime.php and DefaultDateTimeParser.php int...