title: SQL- Difference between TIMESTAMP, DATE AND TIMESTAMP WITH TIMEZONE?
body: <p>What is the difference between <code>TIMESTAMP</code> , <code>DATE</code> AND <code>TIMESTAMP with TIMEZONE</code>?</p>
  
  <p>E.g if I wanted to search for all entries between <code>01-JAN-1990</code> and  <code>01-JAN-2000</code>  , how would I do so in each format?</p>
  
  <p>I have been searching for timestamp as:</p>
  
  <pre><code>SELECT COUNT(*) FROM TABLE_NAME WHERE DATE BETWEEN '01-JAN-1990' AND '01-JAN-2000;
  </code></pre>
  
  <p>But I am not sure what format to use to search for <code>DATE</code> or <code>TIMESTAMP WITH TIMEZONE</code>. </p>