我需要你的帮助.我正在try 将文本字段(包含:2020-09-11T08:32:50Z)转换为日期字段.我try 了TIMESTAMP语句,得到了警告:1292截断了错误的datetime值.
谢谢!
我需要你的帮助.我正在try 将文本字段(包含:2020-09-11T08:32:50Z)转换为日期字段.我try 了TIMESTAMP语句,得到了警告:1292截断了错误的datetime值.
谢谢!
MySQL能够理解"Z"之前的格式.如果删除"Z",它将正常工作.
演示:
mysql> select date('2020-09-11T08:32:50Z');
+------------------------------+
| date('2020-09-11T08:32:50Z') |
+------------------------------+
| 2020-09-11 |
+------------------------------+
1 row in set, 1 warning (0.01 sec)
mysql> show warnings;
+---------+------+------------------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------------------+
| Warning | 1292 | Truncated incorrect datetime value: '2020-09-11T08:32:50Z' |
+---------+------+------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select date('2020-09-11T08:32:50');
+-----------------------------+
| date('2020-09-11T08:32:50') |
+-----------------------------+
| 2020-09-11 |
+-----------------------------+
1 row in set (0.00 sec)
如果删除"Z",则不会返回警告.