I want you to filter the rows between a date range but I only want you to return the rows of a time range of each of the days included in the previous date range.
For example, you would like to filter out all the rows between March 1 and March 3, 2020 and also only those between 14:00 and 18:00.
So far I can filter between two dates or between two hours but it doesn't work when I put the two things together. I don't get any records.
and BEGIN_INTERVAL_TIME BETWEEN to_date('19/04/2020', 'DD/MM/YYYY') AND to_date('20/04/2020','DD/MM/YYYY') and BEGIN_INTERVAL_TIME BETWEEN to_date('15:00:00', 'HH24:MI:SS') AND to_date('16:00:00','HH24:MI:SS')