我尝试向表中输入值,但得到以下错误
"Incorrect datetime value: '09:40 AM' for column"
CREATE TABLE Class_Section (
crn char(5) NOT NULL Primary key,
dept_code char(3) NOT NULL,
course_num char(3) NOT NULL,
meeting_days varchar(6) NULL ,
start_time datetime NULL,
end_time varchar(8) NULL,
campus_code varchar(3) NOT NULL,
location varchar(6) NOT NULL,
faculty_id char(4) NOT NULL,
enrollment TINYINT NOT NULL,
capacity TINYINT NOT NULL,
);
INSERT INTO Class_Section (
CRN, dept_code, course_num, meeting_days, start_time, end_time, campus_code, location, faculty_id, enrollment, capacity
)
VALUES ('20761', 'PSY', '101', 'MW', '09:40 AM', '11:10 AM', 'WC','E-527', 'F002', 40, 40
);谢谢
发布于 2014-02-18 16:35:54
使用时间数据类型
并且您在创建表时在列的末尾使用了逗号
CREATE TABLE Class_Section
(
crn char(5) NOT NULL Primary key,
dept_code char(3) NOT NULL,
course_num char(3) NOT NULL,
meeting_days varchar(6) NULL ,
start_time Time NULL,
end_time Time NULL,
campus_code varchar(3) NOT NULL,
location varchar(6) NOT NULL,
faculty_id char(4) NOT NULL,
enrollment TINYINT NOT NULL,
capacity TINYINT NOT NULL
);
INSERT INTO Class_Section ( CRN, dept_code, course_num, meeting_days, start_time, end_time, campus_code, location, faculty_id, enrollment, capacity ) values ('20761', 'PSY', '101', 'MW', '09:40:00', '11:10:00', 'WC','E-527', 'F002', 40, 40);Fiddle Demo
发布于 2014-02-18 16:37:40
这是你的问题的SQL Fiddle。
start_time具有格式为'YYYY-MM-DD HH:MM'的DateTime类型
发布于 2014-02-18 16:37:51
以此格式指定日期时间字段
'9999-12-31 23:59:59'https://stackoverflow.com/questions/21847971
复制相似问题