title: Oracle DB Query Timestamp with Like and '%'
body: <p>I want to list all records that whose <code>TARGET_COMMIT</code> field days between 10/Nov/2018 and 18/Nov/2018 at around 5.00 AM. I have been using this query:</p>
  
  <pre><code>select * from (select * from GGS_ADMIN.GGS_HEARTBEAT_HISTORY  
  where DELGROUP='REPDELTA' and TARGET_COMMIT between '10/Nov/2018' 
  and '18/Nov/2018') where TARGET_COMMIT like '%/Nov/2018 5:%:%.% AM';
  </code></pre>
  
  <p>Here is one record of my inner query result:</p>
  
  <pre><code>SBLPROF,    EDELTA, 11/10/2018 5:56:22.064830 AM,   11/10/2018 
  5:56:27.495548 AM,
  11/10/2018 5:56:24.731541 AM,   2.666711,               11/10/2018 
  5:56:26.305759 AM,  REPDELTA    ,   5.430718,   3,  11/10/2018 
  5:56:22.820934 AM,  0,  14441,  0,  14441
  </code></pre>
  
  <p>And here "11/10/2018 5:56:27.495548 AM" is my TARGET_COMMIT field.</p>
  
  <p>If use </p>
  
  <pre><code>select * from (select * from GGS_ADMIN.GGS_HEARTBEAT_HISTORY where 
  DELGROUP='REPDELTA' and TARGET_COMMIT between '10/Nov/2018'  and 
  '18/Nov/2018') where TARGET_COMMIT like '11/10/2018 5:56:27.495548 AM'
  </code></pre>
  
  <p>instead of my previous query it matches and lists the result. Why I can't use the "like" function and "%" for timestamp?</p>
  
  <p>By the way here is my dual result:</p>
  
  <pre><code>select sysdate from dual; 
  
    SYSDATE                 
  11/18/2018 04:11:53 PM 
  1 row selected.
  </code></pre>
  
  <p>Thanks in advance!</p>