语法: select t*,t.rowid from DataBaseName where time >= to_date(‘2020-6-1’,‘yyyy-mm-dd’) and time2 <= to_date(‘2020-7-24’,‘yyyy-mm-dd’)
或者是 select t*,t.rowid from DataBaseName where time between to_date(‘2020-6-1’,‘yyyy-mm-dd’) and to_date(‘2020-7-24’,‘yyyy-mm-dd’)