In most databases, DATEDIFF provides the whole number of intervals between the start and end dates. ClickHouse rounds those values. For example a 4 day interval registers as a week. SELECT ...
Cuireadh roinnt torthaí i bhfolach toisc go bhféadfadh siad a bheith dorochtana duit
Taispeáin torthaí dorochtana