MrChen222 opened a new issue, #13465: URL: https://github.com/apache/doris/issues/13465
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version 1.1 ### What's Wrong? 使用cast转换和date_format查询数据不一致 pay_time 是datetime类型用date_format(pay_time, '%Y-%m-%d') BETWEEN '2022-01-01' and '2022-08-31'可以查出数据，用cast(pay_time as date) BETWEEN '2022-01-01' and '2022-08-31'查不出数据。 ### What You Expected? 期望修复这个bug，得到相同的结果 ### How to Reproduce? 用date_format和cast分别转换datetime类型的字段使用ETWEEN '2022-01-01' and '2022-08-31' 一段时间出现BUG ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
