I would like to know what is the equivalent to
$__timeGroup(dateColumn,‘5m’, 0) in MySQL. I am specifically interested about the part that makes missing values to be 0.
I know that something like
unix_timestamp(concat(DATE_FORMAT(dateColumn, '%Y-%m'), '-01')) as time can be used. But this does not cover the cases when the value is missing.