blocks|key|5115018|text|使用时间数据类型|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5115019|并且您在创建表时在列的末尾使用了逗号|offset|length|style|BOLD|5115020|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);|code-block|syntax|javascript|5115021|Fiddle+Demo|5115022|entityMap|0|LINK|mutability|MUTABLE|url|http://sqlfiddle.com/#!2/e0e41^0|0|G|2|0|0|0|B|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|11|8|@]|9|@$D|12|E|13|1|14]]|A|$]]|$1|O|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

Use Time Datatype

And You have used Comma at the end of column while creating table

<pre><code>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);
</code></pre>

<h1><a href="http://sqlfiddle.com/#!2/e0e41" rel="nofollow">Fiddle Demo</a></h1>

blocks|key|1261367|text|这是你的问题的SQL+Fiddle。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1261368|start_time具有格式为'YYYY-MM-DD+HH:MM'的DateTime类型|1261369|entityMap|0|LINK|mutability|MUTABLE|url|http://sqlfiddle.com/#!2/6e869/1|1|https://dev.mysql.com/doc/refman/5.1/en/datetime.html^0|7|A|0|0|F|I|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

Here's a <a href="http://sqlfiddle.com/#!2/6e869/1" rel="nofollow">SQL Fiddle</a> for your question.

The start_time has a DateTime type which has a format of <a href="https://dev.mysql.com/doc/refman/5.1/en/datetime.html" rel="nofollow">'YYYY-MM-DD HH:MM'</a>

blocks|key|1330978|text|以此格式指定日期时间字段|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1330979|++++'9999-12-31+23:59:59'|code-block|syntax|javascript|1330980|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

specify the datetime field in this format

<pre><code> '9999-12-31 23:59:59'
</code></pre>

blocks|key|3646931|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3646932|+assignment说start_time是datetime。|blockquote|offset|length|style|CODE|3646933|3646934|3646935|除非您传递的是日期值，而是时间作为日期时间字段输入的一部分，否则引擎不会仅将时间理解为日期和时间。如果您在课程开始日期和结束日期上预先确定了日期和时间，请以MySQL可理解的格式输入它们。|3646936|如果您有单独的日期值和时间值，则可以将它们组合在一起以形成日期时间值。|3646937|下面是一些示例：|3646938|示例1|BOLD|3646939|如果您将日期和时间作为单独的值：|3646940|insert+into+tbl(+col_of_type_datetime+)+values(+curdate(),+'09:40+AM'+);
insert+into+tbl(+col_of_type_datetime+)+values(+'2014-02-18',+'09:40+AM'+);|code-block|syntax|javascript|3646941|示例2|3646942|如果您有一个已知的时间戳值：|3646943|insert+into+tbl(+col_of_type_datetime+)+values(+now()+);
insert+into+tbl(+col_of_type_datetime+)+values(+'2014-02-18+15:10:34'+);|3646944|示例3|3646945|如果只有date，但now+time值：|3646946|insert+into+tbl(+col_of_type_datetime+)+values(+cast(+curdate()+as+datetime+)+);
insert+into+tbl(+col_of_type_datetime+)+values(+curdate()+);
insert+into+tbl(+col_of_type_datetime+)+values(+cast('2014-02-18'+as+datetime)+);
insert+into+tbl(+col_of_type_datetime+)+values(+'2014-02-18'+);|3646947|entityMap^0|0|C|A|N|8|0|0|0|0|0|0|0|3|0|0|0|0|3|0|0|0|0|3|0|0|0^^$0|@$1|2|3|-4|4|5|6|1D|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|1E|7|@$D|1F|E|1G|F|G]|$D|1H|E|1I|F|G]]|8|@]|9|$]]|$1|H|3|-4|4|5|6|1J|7|@]|8|@]|9|$]]|$1|I|3|-4|4|5|6|1K|7|@]|8|@]|9|$]]|$1|J|3|K|4|5|6|1L|7|@]|8|@]|9|$]]|$1|L|3|M|4|5|6|1M|7|@]|8|@]|9|$]]|$1|N|3|O|4|5|6|1N|7|@]|8|@]|9|$]]|$1|P|3|Q|4|5|6|1O|7|@$D|1P|E|1Q|F|R]]|8|@]|9|$]]|$1|S|3|T|4|5|6|1R|7|@]|8|@]|9|$]]|$1|U|3|V|4|W|6|1S|7|@]|8|@]|9|$X|Y]]|$1|Z|3|10|4|5|6|1T|7|@$D|1U|E|1V|F|R]]|8|@]|9|$]]|$1|11|3|12|4|5|6|1W|7|@]|8|@]|9|$]]|$1|13|3|14|4|W|6|1X|7|@]|8|@]|9|$X|Y]]|$1|15|3|16|4|5|6|1Y|7|@$D|1Z|E|20|F|R]]|8|@]|9|$]]|$1|17|3|18|4|5|6|21|7|@]|8|@]|9|$]]|$1|19|3|1A|4|W|6|22|7|@]|8|@]|9|$X|Y]]|$1|1B|3|-4|4|5|6|23|7|@]|8|@]|9|$]]]|1C|$]]

<blockquote>
 assignment said <code>start_time</code> as <code>datetime</code>.
</blockquote>

Unless you pass a date value, but the time, as part of a datetime field input, the engine won't understand just the time as a date and time. If you have pre-decided date and time on a course start date and end date, then input them in MySQL understandable formats.

If you have date and time values separately, you can combine them to form a datetime value. 
Following are some examples: 

Example 1: 
If you have date and time as separate values: 

<pre><code>insert into tbl( col_of_type_datetime ) values( curdate(), '09:40 AM' );
insert into tbl( col_of_type_datetime ) values( '2014-02-18', '09:40 AM' );
</code></pre>

Example 2: 
If you have a known timestamp value: 

<pre><code>insert into tbl( col_of_type_datetime ) values( now() );
insert into tbl( col_of_type_datetime ) values( '2014-02-18 15:10:34' );
</code></pre>

Example 3: 
If you have only date but now time value: 

<pre><code>insert into tbl( col_of_type_datetime ) values( cast( curdate() as datetime ) );
insert into tbl( col_of_type_datetime ) values( curdate() );
insert into tbl( col_of_type_datetime ) values( cast('2014-02-18' as datetime) );
insert into tbl( col_of_type_datetime ) values( '2014-02-18' );
</code></pre>

blocks|key|1330931|text|检查您是否已声明|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1330932|start_time+datetime+,

end_time+varchar(8)|code-block|syntax|javascript|1330933|但在插入时，您发送的是'09:40+AM',+'11:10+AM'。所以请检查一下你的数据类型。|offset|length|style|CODE|1330934|entityMap^0|0|0|B|M|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Check that you have declared 

<pre><code>start_time datetime ,

end_time varchar(8)
</code></pre>

but while inserting, you are sending <code>'09:40 AM', '11:10 AM'</code> . So please check your datatypes once.

blocks|key|3646827|text|因为您将start_time声明为datetime+NULL，而mysql需要一个datetime值。使用与end_time相同的类型(+varchar(8)+NULL)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3646828|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Because you declare start_time as datetime NULL, and mysql expects a datetime value.
Use the same type as end_time ( varchar(8) NULL)

I try to enter values to the table and i got this error

<code>"Incorrect datetime value: '09:40 AM' for column"</code>

<pre><code>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
 );
</code></pre>

Thank you

MySQL Incorrect datetime value: '09:40 AM' for column

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我尝试向表中输入值，但得到以下错误"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_

问MySQL列的日期时间值不正确：'09:40 AM‘
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL列的日期时间值不正确：'09:40 AM‘EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL列的日期时间值不正确：'09:40 AM‘
EN