Help to take a look at this access where clause in the what's the problem-CodePudding

Home > database > Help to take a look at this access where clause in the what's the problem

Help to take a look at this access where clause in the what's the problem

Time：03-12

WHERE DateDiff (" d ", CDate (Mid (production end time, 1, 4) + "-" + Mid (production end time, 5, 2) + "-" + Mid (production end time, 7, 2)), "2020-08-31") & gt; 180
To "standard expression data type mismatch"
Through the CDate type the text into a date in DateDiff calculation, to see if the result is more than 180 days,

The DateDiff above statement to write in a select statement can be detected data, can't DateDiff results compared with the numerical?

Page link：https//www.codepudding.com/database/104230.html

Prev:Kettle cleaning the hive data, the data in the following Error Error to clickhouse setting value # 1

Next:Mysql DML transaction commit problem, consult!!!!!!

Tags：

Access

Links：
CodePudding