MySQL字段DATETIME截断ISO8601 [英] MySQL field DATETIME truncates ISO8601
本文介绍了MySQL字段DATETIME截断ISO8601的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
具有类似创建的MySQL/MariaDB表
Having MySQL/MariaDB table created like
CREATE TABLE `testTable` (
`id` int(11) NOT NULL,
`timeinfo` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
并插入像这样的完整ISO8601值:
And inserted with full ISO8601 value like this:
MariaDB [test]> INSERT INTO testTable VALUES (1, '2500-12-31T00:00:00.000Z');
Query OK, 1 row affected, 1 warning (0.00 sec)
MariaDB [test]> show warnings;
+---------+------+-----------------------------------------------+
| Level | Code | Message |
+---------+------+-----------------------------------------------+
| Warning | 1265 | Data truncated for column 'timeinfo' at row 1 |
+---------+------+-----------------------------------------------+
1 row in set (0.00 sec)
MariaDB [test]> select * from testTable;
+----+---------------------+
| id | timeinfo |
+----+---------------------+
| 1 | 2500-12-31 00:00:00 |
+----+---------------------+
1 row in set (0.01 sec)
我没有完全看到被截断的内容,如ZULU TimeZone中的"Z"吗?
I don't exactly see what is being truncated, the "Z" as in ZULU TimeZone ?
是否可以将信息完全包含在MySQL/MariaDB字段类型中?
Is it possible to contain the information fully in MySQL/MariaDB field type?
如果是,应该使用哪种字段数据类型?
If so which field data type should be used?
推荐答案
数据库需要另一个输入,这就是为什么您收到警告的原因
The database expects another input that is why you get the warning
在MySQL中,DATETIME需要以下格式
DATETIME-格式:YYYY-MM-DD HH:MI:SS
DATETIME - format: YYYY-MM-DD HH:MI:SS
这不会产生任何警告:
INSERT INTO testTable VALUES (, '2500-12-31 00:00:00');
即使发出警告,数据库也会填充您的记录.
Even with your warnings the database will fill you record.
这篇关于MySQL字段DATETIME截断ISO8601的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文