1 oracle按照日期查询语句
-- queryFuturesProfitInfo
select *
from interface_log t
where
t.type='queryFuturesProfitInfo'
--and t.create_time is not null
and t.create_time>to_date('2022-11-20','yyyy-mm-dd')
and t.create_time<to_date('2022-11-28','yyyy-mm-dd')
order by t.create_time desc;
2 oracle按照日期时间查询语句
-- queryFuturesProfitInfo
select *
from interface_log t
where
t.type='queryFuturesProfitInfo'
--and t.create_time is not null
and t.create_time>to_date('2022-11-20 17:55:00','yyyy-mm-dd hh24:mi:ss')
and t.create_time<to_date('2022-11-20 18:10:00','yyyy-mm-dd hh24:mi:ss')
order by t.create_time desc;