date_part('day',cast(now() as TIMESTAMP)-cast(inserttime as TIMESTAMP)) < 2
这种也可以
select * from tablet where insert_time_for_his > current_date - interval '2.5 year'
date_part('day',cast(now() as TIMESTAMP)-cast(inserttime as TIMESTAMP)) < 2
这种也可以
select * from tablet where insert_time_for_his > current_date - interval '2.5 year'