title: I need to fetch the records that are between these DATE and DATE_TIME Column
body: <p>I have a AUDIT Table in Oracle with DATE_AND_TIME as DATE and DATE_AND_TIME_24HOUR_FORMAT as Varchar2. I need to fetch records that are between two Date and DATE_AND_TIME_24HOUR_FORMAT. for example</p>
  <pre><code>Record  Date_AND_TIME   DATE_AND_TIME_24HOUR_FORMAT 
  1   02-Feb-2022 13:35:24    
  2   02-Feb-2022 13:35:56    
  3   07-Feb-2022 13:35:32    
  4   07-Feb-2022 13:35:23    
  5   07-Feb-2022 13:35:02    
  6   07-Feb-2022 13:36:02    
  </code></pre>
  <p>I need the Query which will fetch me records 3,4,5 if I execute it for 03-FEB-2022 13:35:00 to 07-FEB-2022 13:35:00 and record 6 if I execute the query for 07-FEB-2022 13:36:00 to 12 07-FEB-2022 13:37:00.</p>