日期范围查询
select * from tableName t
where t.tel = '手机号码'
and t.createDate >to_date('20210401 000000','yyyymmdd hh24miss')
and t.createDate<to_date('20210401 235959','yyyymmdd hh24miss');
日期范围查询
select * from tableName t
where t.tel = '手机号码'
and t.createDate >to_date('20210401 000000','yyyymmdd hh24miss')
and t.createDate<to_date('20210401 235959','yyyymmdd hh24miss');