Oracle时间范围查询

select * from sj.g_wip_sn_detail g where g.d_t between to_date('2020-07-03 08:00:00', 'YYYY-MM-DD hh24:mi:ss') and to_date('2020-07-04 08:00:00', 'YYYY-MM-DD hh24:mi:ss') and g.report_name = 'CIT' order by g.d_t desc;