56,677
社区成员
发帖
与我相关
我的任务
分享mysql中ERROR 1292是什么错误？
数据库表中有一列是PlanStartTime，类型是date,用insert插入的时候给该列插入的是01-03-2010却提示错误，请各位看看是怎么回事了
ERROR 1292 (22007): Incorrect date value: '-2012' for column 'PlanStartTime' at row 1
整个插入语句：
mysql> insert into testoutfitempolder(ProductRoute, Product, Edition, Veneer, PCBEdition, SetupType,VeneerLomplex, TestPointNum, BSOvercast, PlanStartTime, Pla
nEndTime, TaskDemand, DFTPrincipal, StartCause, TR5Time, HasTemplet, UpgradeDesc
, Remark) values("无线1", "产品1", "版本1", "单板1", "A", "Develop", 45.00,
1000, "53.00%", 01-03-2010, 05-03-2010, "设备1", "接口人1", "开发1", 04-03-2010,
'Y', "", "无升级描述");
ERROR 1292 (22007): Incorrect date value: '-2012' for column 'PlanStartTime' at row 1
整个插入语句：
mysql> insert into testoutfitempolder(ProductRoute, Product, Edition, Veneer, PCBEdition, SetupType,VeneerLomplex, TestPointNum, BSOvercast, PlanStartTime, Pla
nEndTime, TaskDemand, DFTPrincipal, StartCause, TR5Time, HasTemplet, UpgradeDesc
, Remark) values("无线1", "产品1", "版本1", "单板1", "A", "Develop", 45.00,
1000, "53.00%", 01-03-2010, 05-03-2010, "设备1", "接口人1", "开发1", 04-03-2010,
'Y', "", "无升级描述");
...全文
请发表友善的回复…
发表回复
ccmfk 2010-05-20
- 打赏
- 举报
谢谢两位了
iihero_ 2010-05-20
- 打赏
- 举报
用格式：
insert into testoutfitempolder(.....) values( ......, '2010-01-03'
insert into testoutfitempolder(.....) values( ......, '2010-01-03'
ACMAIN_CHM 2010-05-20
- 打赏
- 举报
'04-03-2010',
加上单引号。否则MYSQL会把它计算成数字-2009了。
加上单引号。否则MYSQL会把它计算成数字-2009了。
