In Metabase, when utilizing the interval function, the output is formatted as follows:
0 years 0 mons 2 days 0 hours 7 mins 44.0 secs
using the justify_interval
function from PostgreSQL. However, I would like to display the output in the original JSON format of the function, which is as follows:
{
"years": 0,
"mons": 0,
"days": 2,
"hours": 0,
"mins": 7,
"secs": 44.0
}