【Oracle】查询date类型指定日期的数据

//查询date类型指定日期的数据

select * from table_name
where create_time >= to_date('20230404000000','yyyymmddhh24miss')
and create_time < to_date('20230404000000','yyyymmddhh24miss')

//查询表中切分后等于目标字符串的数据
例如表中stock的数据为123456.OF、123456.SZ

select * from table_name
where substr(stock,1,6)='123456'