Something like https://dev.mysql.com/doc/refman/8.0/en/time.html (maybe domain using Decimal for example).

Some Mysql drivers are unable to work using Mysql wire protocol because of lack of Time datatype (they use this type on connect for some internal needs).

Also Tableu treats Clickhouse compatible on 98%

Other databases also have Time or Interval type and use this type operations with DateTime

Like

SELECT (now() + 30000) - now()
┌─minus(plus(now(), 30000), now())─┐
│                            30000 │
└──────────────────────────────────┘