传进来两个日期就行了呀,可以用 between and 或者直接大于小于拼接时间
select * from table a where a.time between date '2022-01-01' and date '2022-10-11' ; select * from table a where a.time <=date '2022-01-01' and a.time>='2022-10-11' ;