Your statement is plain and simle wrong!
This behavior is correct, if you add 10 hours to "2025-06-10T14:00:00"
, you will get the end of June 10, which is "2025-06-11T00:00:00"
.
2025-06-11T00:00:00 is NOT the beginning of 11th but its end!!! So by adding 10 hours your data is being set at 10 hours plus 24 hours which rhrows all queries and analytical scenarios out the winodw.
I don’t kknow how else to explain it - but a time management system that does not know how to calculate time is a little bit strange!