wsg96321 opened a new issue, #12088: URL: https://github.com/apache/doris/issues/12088
### 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 apache-doris-1.1.1 ### What's Wrong? wheen use from_unixtime function in mysql client , it return wrong count and detail data from sql . like below:  ### What You Expected? it should return the same data with %s and %S in mysql date formate . which in my examle , it should also return 24 record instead of 18 record. ### How to Reproduce? create a unique table with long type of createtime. then select the data from it with from_unixtime and use %s or %s formate. ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
