alfasoftware/morf

Make database time reporting consistent for all supported database platforms.

Closed this issue · 1 comments

This includes updates to improve consistency between the application and database reported times by returning UTC in all cases. This prevents timezone differences on application startup.

Further, a bug in MySQL (https://stackoverflow.com/questions/26515700/mysql-jdbc-driver-5-1-33-time-zone-issue/33893008#33893008) results in the incorrect time being returned from the database, as it uses the calendar time of the application system. This results in production problems when the database and system times are not synchronized. Addition of the parameter "useJDBCCompliantTimezoneShift=true" to the MySQL JDBC url is the suggested fix from MySQL for the connector version being used.

Resolved in master.