ClickHouse时间查询
1、近几个小时
SELECT
tactics_date
FROM
la_potential_danger
where
subtractHours(tactics_date, 7) > toDate(now())
2、今天
SELECT
tactics_date
FROM
la_potential_danger
where
toDate(tactics_date) = today()
3、昨天
SELECT
tactics_date
FROM
la_potential_danger
where
toDate(tactics_date) = yesterday()
4、近几天
SELECT
tactics_date tacticsD