table.createdate between to_date('2021/01/01', 'YYYY/MM/DD') AND to_date('2021/07/01', 'YYYY/MM/DD')
或者 table.createdate>to_date('2021/01/01', 'YYYY/MM/DD')