[TZ dates in MySQL]

tz_dates_mysql.md

Timezoned dates in MySQL 🐬

Problem 😿

Error: ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: '2017-10-10T06:50:04.006Z' for column 'created_at' at row 1

Solution 😺

MySQL config, e.g.: /etc/mysql/my.cnf

[mysqld]
sql-mode="NO_ENGINE_SUBSTITUTION" # default is "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"

(this is for mysql ^5.7.8, for older see link)