Open bibichuan opened 2 years ago
For better global communication, please give priority to using English description, thx!
Describe the question In the generated sql, there is a %, which causes the sql server to not recognize it. How to solve this?
Which version of DataX Web: -[2.1.1]
Additional context
执行的SQL为: select * from realtime where RecordTime >= '2010-01-01%00:00:00' and RecordTime < '2022-01-10%18:21:28' 具体错误信息为：com.microsoft.sqlserver.jdbc.SQLServerException: 从字符串转换日期和/或时间时，转换失败。 2022-01-10 18:21:40 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
**Requirement or improvement
bibichuan
commented
2 years ago 
bibichuan
commented
2 years ago
For better global communication, please give priority to using English description, thx!
Describe the question In the generated sql, there is a %, which causes the sql server to not recognize it. How to solve this?
Which version of DataX Web: -[2.1.1]
Additional context
执行的SQL为: select * from realtime where RecordTime >= '2010-01-01%00:00:00' and RecordTime < '2022-01-10%18:21:28' 具体错误信息为：com.microsoft.sqlserver.jdbc.SQLServerException: 从字符串转换日期和/或时间时，转换失败。 2022-01-10 18:21:40 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
**Requirement or improvement