Question

数据库小白在线提问：从字符串转换日期和/或时间时，转换失败？

这是代码：
insert into SPDGB
values ('100001','10010001','2013-02-18 12:20:00',2,'2013-02-20','现金','客户自取'),
('100001','30010001','2013-02-10 12:30:00',10,'2013-02-20','现金','客户自取'),
('100002','10010001','2013-02-18 13:00:00',1,'2013-02-21','现金','客户自取'),
('100002','50020001','2013-02-18 13:20:00',1,'2013-02-21','现金','客户自取'),
('100004','20180002','2013-02-19 10:00:00',1,'2013-02-28','信用卡','送货上门'),
('100004','50020002','2013-02-19 10:40:00',2,'2013-02-28','信用卡','送货上门'),
('100004','30010002','2013-02-19 11:00:00',10,'2013-02-28','信用卡','送货上门'),
('100005','40010001','2013-02-20 08:00:00',2,'2013-02-27','现金','送货上门'),
('100005','40010002','2013-02-20 08:20:00',3,'2013-02-27','现金','送货上门'),
('100006','10020001','2013-02-23 09:00;00',5,'2013-02-26','信用卡','送货上门')

Answer 1

这个sql没问题的，你是用什么数据库？先看表格式对应字段的定义是不是datetime。如果是，可以用对应数据库的日期时间转换函数 。