insert语句问题
INSERT INTO TB_ACC_PAYABLE ( vcAspID,vcPayableID,vcPayableCode,vcCompanyCode, vcComfrom,vcPerson, vcMoneyCode,fRate,vcTaxWay,
vcDeptCode,fPayMoneyW, fPayMoneyB,fPayTaxB,fPayAllMoneyB,fPayedlMoneyB, vcTradeWay,vcAccSubjectID,
vcCreator,dCreateDate, dModifyDate,vcAuditor,dAuditDate,vcStatus, vcMemo,vcBillType)
VALUES( 'mulaolao ', 'AF0705142302671 ', 'AF0705142302671 ', 'wz106 ', 'BI070372 ', 'admin ', '01 ',1, '内含税 ', '07 ',20,20,0,20,0,
'先付100%预付款,余款在出货后10天内根椐发票付清 ', '应付帐款 ', 'admin ',
TO_DATE( '2007-05-14 ', 'YYYY-MM-DD ') ',
TO_DATE( '2007-05-14 ', 'YYYY-MM-DD '), 'admin ',
TO_DATE( '2007-05-14 ', 'YYYY-MM-DD '), '正式启用 ', ' ', '应付单 ')
执行时提示括号内的字符串没有正确结束,不知道什么意思?
------解决方案--------------------TO_DATE( '2007-05-14 ', 'YYYY-MM-DD ') ',最后多了个单引号