Timediff returning unexpected results - MySQL

SELECT TIMEDIFF(convert_tz('2020-01-25 13:10:11', '+00:00','+05:30'), convert_tz('2020-01-15 13:10:10', '+00:00','+05:30'));

Running this on MySQL returns

10 days 00:00:01

whereas running this on Metabase returns

12:00 AM

.

Any solution?

Hi @testout
MySQL should return 240:00:01 - likely the query tool you are using if formatting it differently.
Metabase does currently not support duration/interval type:
https://github.com/metabase/metabase/issues/8875 - upvote by clicking :+1: on the first post
You can do something like this as a workaround:
https://stackoverflow.com/questions/5279079/mysql-convert-timediff-output-to-day-hour-minute-second-format