To write mtr tests easier, we'll add CAST(x AS INTERVAL DAY_SECOND(N)).
For now it will return a VARCHAR with a specific format:
It will be helpful to write tests with functions that now understand long time intervals:
- TIMESTMP(ts, time_interval)
- ADDTIME(ts, time_interval)
- EXTRACT(DAY FROM src)
So in this query:
it will be clear how the day and the hour value are calculated.