5,889
社区成员
发帖
与我相关
我的任务
分享新手,急!!!!一个简单的SQL语句,总出错!!!!
insert into KENKO_HOKEN_JIGYOSHO(KSHA_CD,STRT_DT,KP_JIGYO_CD,YK_F,KP_JIGYO_NM,KENPO_KM_KB,JIGYO_NM,JYB_NO,JTDFK_CD,JSKCS_CD,JJSHO1,JNSSM,HS_DT,KSNSHA_CD,KSN_DTM) values ('00001',current date,'3002','1','1','1','TEST','40002', '4','3','T1','UY1','0-00-00','A', current timestamp )
...全文
请发表友善的回复…
发表回复
haojie 2005-02-23
- 打赏
- 举报
'0-00-00'是日期吗?
haojie 2005-02-23
- 打赏
- 举报
什么错误呢?
javaSky82 2005-02-23
- 打赏
- 举报
insert into KENKO_HOKEN_JIGYOSHO(KSHA_CD,STRT_DT,KP_JIGYO_CD,YK_F,KP_JIGYO_NM,KENPO_KM_KB,JIGYO_NM,JYB_NO,JTDFK_CD,JSKCS_CD,JJSHO1,JNSSM,HS_DT,KSNSHA_CD,KSN_DTM) values ('20002',DATE('1999-04-01'),'3004','1','1','1','TEST','40002', '4','3','T1','UY1',current date,'A', current timestamp )
