title: SQL- Ensuring query does not include results where a certain column in null?
body: <p>Below is the query I am using in order to check how many rows in my table have a date <em>older than</em> <code>01/01/2015 (TIMESTAMP).</code> </p>
  
  <p>How can I alter this query to ensure that it <em>does not</em> include any results where the <code>DATE_INSERTED</code> column is <code>null</code>?</p>
  
  <p>Also, if this is not the most <em>efficient</em> way to check for this condition, I would appreciate alternatives. </p>
  
  <p>Current query:</p>
  
  <pre><code>SELECT COUNT(*)
  FROM TABLE_NAME
  WHERE DATE_INSERTED NOT BETWEEN '01-JAN-2015 00.00.00.00' AND '18-JAN-2016 00.00.00.00';
  </code></pre>