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;
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;