Issue when saving datetime

[itsrachelfish]

It seems like there is an issue when dates are saved (on the production server at least). The created date is being saved in MST but the modified date is being saved in UTC. This might be because the MySQL server is configured to use MST but laravel is configured to use UTC. The created_at column is updated by using a default value in the database where updated_at is actually generated by Laravel.

This might be a common / known issue in Laravel, I think it would be worth looking in the documentation or Laravel support forums.

[marcj303]

This might solve the issue:
http://laravel.io/forum/10-16-2015-set-default-mysql-timezone-on-connect

You can add the following key to your mysql connection in the config:
'options' => array(
\PDO::MYSQL_ATTR_INIT_COMMAND => 'SET time_zone = '+00:00''
)
This example sets your PDO database connection to UTC. So if the database itself runs in another timezone, your app wil always get the timestamps as UTC.

[marcj303]

I think this might have been resolved in the laravel update.

[itsrachelfish]

@marcj303 I actually fixed this on production by modifying the database settings manually.

Going to leave this issue open until we upgrade the version of Laravel we're using.

[itsrachelfish]

We should double check to see if this issue is still relevant.