"Date Data" database access in XML schema format

There was an error when the date data in the XML Schema format was stored in the DateTime field in the database

Mysql> SELECT @ @sql_mode; +--------------------------------------------+| @ @sql_mode |+--------------------------------------------+| Strict_trans_tables,no_engine_substitution |+--------------------------------------------+1 row in Set (0.00 sec) mysql> INSERT INTO datetimetest (DT) VALUES (' 2013-08-26t12:00:00+00:00 '); ERROR 1292 (22007): Incorrect datetime value: ' 2013-08-26t12:00:00+00:00 ' for column ' dt ' at row remove strict_trans_t ABLES--Note that executing this is removes it for your--current session--it does don't make a server-wide config chan gemysql> SET @ @sql_mode = ' no_engine_substitution '; Query OK, 0 rows Affected (0.00 sec) mysql> SELECT @ @sql_mode; +------------------------+| @ @sql_mode |+------------------------+| No_engine_substitution |+------------------------+1 row in Set (0.00 sec) – now MySQL would accept the invalid value, with A warningmysql> insert INTO datetimetest (DT) VALUES (' 2013-08-26t12:00:00+00:00 '); Query OK, 1 row affected, 1 Warning (0.00 sec) mysql> Show warnings;+---------+------+-------------------------------- ---------+| Level | Code | Message |+---------+------+-----------------------------------------+| Warning | 1265 | Data truncated for column ' DT ' at row 1 |+---------+------+-----------------------------------------+1 row in Set (0.00 SE c)--the value did get inserted, but the time zone information is lost:mysql> SELECT * from datetimetest;+----+------- --------------+| ID |  DT |+----+---------------------+| 1 | 2013-08-26 12:00:00 |+----+---------------------+1 row in Set (0.00 sec)

　　

So run set directly @ @sql_mode = ' no_engine_substitution ';

"Date Data" database access in XML schema format