Date与DatatimeV2

select * from tbname where adtime=DATE(NOW())，其中adtime是Date类型，DATE(NOW())是DatatimeV2 类型；查询语句是有结果的。删除却报错。

删除报错提示，意为两边日期类型不匹配。只是疑惑既然两边日期类型不匹配那么为什么查询可以出结果，删除语句却报错？还是说doris里不支持在delete里使用DATE(NOW())？

Caused by: java.sql.SQLException: errCode = 2, detailMessage = errCode = 2, detailMessage = Right expr of binary predicate should be value, predicate: `adtime` = CAST(date('2025-07-04 11:53:13') AS DATEV2), right expr type:DATEV2
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:330)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131)
	... 11 more