同步的表里要以日期类型的字段作为参数，不知道要怎么写？
现在写的是 statement => "select * from *** where logintime > to_date(:sql_last_value,'yyyy/mm/dd hh24:mi:ss')"，但是后台报错了Java::JavaSql::SQLException: ORA-01840: 输入值对于日期格式不够长: SELECT * FROM (SELECT count(*) "COUNT" FROM (select * from *** where logintime > to_date(0,'yyyy/mm/dd hh24:mi:ss')) "T1") "T1" WHERE (ROWNUM <= 1)
现在写的是 statement => "select * from *** where logintime > to_date(:sql_last_value,'yyyy/mm/dd hh24:mi:ss')"，但是后台报错了Java::JavaSql::SQLException: ORA-01840: 输入值对于日期格式不够长: SELECT * FROM (SELECT count(*) "COUNT" FROM (select * from *** where logintime > to_date(0,'yyyy/mm/dd hh24:mi:ss')) "T1") "T1" WHERE (ROWNUM <= 1)
1 个回复
laoyang360 - 《一本书讲透Elasticsearch》作者，Elastic认证工程师 [死磕Elasitcsearch]知识星球地址：http://t.cn/RmwM3N9；微信公众号：铭毅天下; 博客：https://elastic.blog.csdn.net
赞同来自: