wenzhenghu opened a new issue, #35585: URL: https://github.com/apache/doris/issues/35585
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version doris-2.0.9-5c2fca80b0 ### What's Wrong? when transfer or trancate a timestamp( in milliseconds) to datetime(seconds), mysql use rounding(四舍五入), while doris truncates directly ### What You Expected? If Doris handle timestamps to datetime in the same way as MySQL（rounding to second）, it would be more friendly for migrating business from MySQL to Doris. ### How to Reproduce? if doris  if mysql  ### 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]
