[K/3Cloud] KSQL日期常量用法注意

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')
posted @ 2013-08-30 11:57  范永强  阅读(317)  评论(0编辑  收藏  举报