|
KSQL中用日期常量必须用{ts'" + dateTime.ToString("yyyy-M-d HH:mm:ss") + "'} 正确写法： INSERT INTO T_SEC_PASSWORDHISTORY (FHISTORYID, FUSERID, FPASSWORD, FCREATEDATE) VALUES ('2c34ef20-89f1-49e7-9756-842a32a248da', 10120, '2F2416BA3BCF5DB18362CAD20CA90089515ABE0F', {ts'2011-8-3 11:09:27'}) 错误写法： INSERT INTO T_SEC_PASSWORDHISTORY (FHISTORYID, FUSERID, FPASSWORD, FCREATEDATE) VALUES ('2c34ef20-89f1-49e7-9756-842a32a248da', 10120, '2F2416BA3BCF5DB18362CAD20CA90089515ABE0F', '2011-8-3 11:09:27') |