range()?
Запрос вида:
SELECT range(today() - toDate('2020-07-01'));
Выдает: Code: 43, e.displayText() = DB::Exception: Illegal type Int32 of argument of function range: While processing range(today() - toDate('2020-07-01')) (version 20.12.4.5 (official build))
perhaps u need dateDiff? https://clickhouse.tech/docs/en/sql-reference/functions/date-time-functions/#date_diff
Обсуждают сегодня