大家看看这条SQL语句错在哪里,为什么时间老插入不进去?

Question

数据库中FTIME字段属性为DATE类型
System.DateTime dt=Convert.ToDateTime(xxxxn_Part.Attributes["修改日期"].InnerText);
Sql="insert into dnc_productprogram(fid,fname,fplantfid,fstructfid,fedition,fmachinefid,fmachine,ftime,fprogramname) values('"+PartID4+"','"+Filename+"','"+FPlantFid+"','"+PartID+"','0','"+fid+"','"+sFmachine+"','"+dt+"',,'"+Filename+"')";
对应调试SQL，以下缺少FTIME字段的SQL能通过，上面多了个FTIME字段的SQL则调试通过不了  
insert into dnc_productprogram(fid,fname,fplantfid,fstructfid,fedition,fmachinefid,fmachine,ftime,fprogramname) values('3e5a1ef1-af2a-4de3-8b46-046c13d74adf','-2026897379_30_NCprog-00550.txt','a9623050-89bf-4955-90fa-80b3abc386d0','e509f7ef-25ea-4cb4-8261-8ccfda45273e','0','b3c61e99-85bf-4306-8760-fb40013e6b06','QQ(FANAC)','2004-8-5 13:44:00',,'-2026897379_30_NCprog-00550.txt')"
Sql="insert into dnc_productprogram(fid,fname,fplantfid,fstructfid,fedition,fmachinefid,fmachine,fprogramname) values('"+PartID4+"','"+Filename+"','"+FPlantFid+"','"+PartID+"','0','"+fid+"','"+sFmachine+"','"+Filename+"')";
对应调试SQL
insert into dnc_productprogram(fid,fname,fplantfid,fstructfid,fedition,fmachinefid,fmachine,fprogramname) values('d893d734-f2c1-4129-8ee4-542270a9daf0','-2026897379_30_NCprog-00550.txt','a9623050-89bf-4955-90fa-80b3abc386d0','57000c63-d8f2-4034-b5a4-0d97a45ce2f3','0','b3c61e99-85bf-4306-8760-fb40013e6b06','QQ(FANAC)','-2026897379_30_NCprog-00550.txt')"
我用下面的TO_DATE转换函数也不行
Sql="insert into dnc_productprogram(fid,fname,fplantfid,fstructfid,fedition,fmachinefid,fmachine,ftime,fprogramname) values('"+PartID4+"','"+Filename+"','"+FPlantFid+"','"+PartID+"','0','"+fid+"','"+sFmachine+"',to_date(dt,'dd-mon-yyyy HH:MI:SS'),'"+Filename+"')";
对应调试SQL
"insert into dnc_productprogram(fid,fname,fplantfid,fstructfid,fedition,fmachinefid,fmachine,ftime,fprogramname) values('f9a2d462-d0bd-43d7-9957-122225cabd63','-2026897379_30_NCprog-00550.txt','a9623050-89bf-4955-90fa-80b3abc386d0','5d89d231-0143-4c85-89bf-a45c89e06d1b','0','b3c61e99-85bf-4306-8760-fb40013e6b06','QQ(FANAC)',to_date(dt,'dd-mon-yyyy HH:MI:SS'),'-2026897379_30_NCprog-00550.txt')"
insert into dnc_productprogram(fid,fname,fplantfid,fstructfid,fedition,fmachinefid,fmachine,ftime,fprogramname) values('6def95b3-5146-443f-8f0b-a56ed9f4c263','-2026897379_30_NCprog-00550.txt','a9623050-89bf-4955-90fa-80b3abc386d0','bef249a3-57dd-4171-a5e5-a804c738037f','0','b3c61e99-85bf-4306-8760-fb40013e6b06','QQ(FANAC)',to_date(dt,'yyyy-mm-dd hh24:mi:ss'),'-2026897379_30_NCprog-00550.txt')
请问时间类型的数据怎么插入啊?

Answer 1

加上FTIME字段后,老是提示 ORA-01861 文字与格式字符串不匹配

Answer 2

to_date(dt,'yyyy-mm-dd hh24:mi:ss'),
是不是dt,不能转换成日期型

Answer 3

楼上说的对
把你需要插入的那个字段先select出来
用你的眼睛看下哪笔有问题,改了

Answer 4

我注意到这句
insert into dnc_productprogram(fid,fname,fplantfid,fstructfid,fedition,fmachinefid,fmachine,ftime,fprogramname) values('3e5a1ef1-af2a-4de3-8b46-046c13d74adf','-2026897379_30_NCprog-00550.txt','a9623050-89bf-4955-90fa-80b3abc386d0','e509f7ef-25ea-4cb4-8261-8ccfda45273e','0','b3c61e99-85bf-4306-8760-fb40013e6b06','QQ(FANAC)','2004-8-5 13:44:00',,'-2026897379_30_NCprog-00550.txt')"
里面，时间ftime的后面多了个逗号，不知道lz在测试的时候是不是也是用的这个，还是
拷到这里的时候多写了。