title: Oracle db get values between specific dates
body: <p>I have this <code>DATETIME</code> field in my oracle database shown in the image</p>
  
  <p><img src="https://i.stack.imgur.com/6WxfN.png" alt="enter image description here"></p>
  
  <p>I'm trying to make a query which returns something between specific dates but this query returns nothing.</p>
  
  <pre><code> SELECT * 
   FROM tbl_meter 
   WHERE TO_DATE(DATETIME,'DD/MM/YYYY') BETWEEN '%s' AND '%s'
  </code></pre>
  
  <p>What am I missing?</p>
  
  <p><strong>EDIT:</strong></p>
  
  <pre><code>SELECT * FROM tbl_meter WHERE DATETIME BETWEEN '15/01/2014' AND '07/01/2014'
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/j1Zdz.png" alt="enter image description here"></p>