Timezone Updates

Prior to version 0.13.0 (unreleased currently) the time zone for dates stored in the database were based on the system time.

Storing based on system time is bad design and all dates should be stored in UTC and converted to the browsers local time later.

If you launched a container or run the default snap the default time zone appears to be UTC so this upgrade shouldn't impact you, if you have have updated the time zone in your container or updated the php.ini file this update will impact you.

This update makes sure all date times are stored UTC so if you have changed the time zone this may result in out of order data for a window as long as the difference between your time zone and UTC.

All stored times (recorded actions, user creation dates ETC) will also be incorrectly displayed because the times are now assumed to be UTC so they will converted to your local time.

Apologies for the inconvenience but its never going to be ideal time to re-configure this behaviour so its better to get it done.