mysql
date_format(a.create_time,’%Y-%m-%d’) between ‘2021-09-01’ and ‘2021-09-21’
oracle
to_char(CREATE_TIME,‘yyyy-MM-dd’) between ‘2021-09-01’ and ‘2021-09-21’
mysql
date_format(a.create_time,’%Y-%m-%d’) between ‘2021-09-01’ and ‘2021-09-21’
oracle
to_char(CREATE_TIME,‘yyyy-MM-dd’) between ‘2021-09-01’ and ‘2021-09-21’