title: How to format date in where?
body: <p>I have this script:</p>
  
  <pre><code>select * from OPDN A 
  where A."DocDate" between '2020/01/01' and '2020/01/31'
  </code></pre>
  
  <p>How to achieve the format "MM/DD/YYYY" in the WHERE clause?</p>
  
  <pre><code>select * from OPDN A 
  where A."DocDate" between '01/01/2020' and '01/31/2020'
  </code></pre>
  
  <p>The column <code>DocDate</code> is of type <code>TimeStamp</code>.</p>