title: sql NOT LIKE syntax
body: <p>I need to filter based on a timestamp and would like to get everything within a certain day. The timestamps are like this: <code>02/06/2014 7:45:59 AM</code> or translated <code>2014-02-06 07:45:59</code></p>
  
  <pre><code>select * 
  from P_FAR_SBXD.T_CLAIM_SERVICE_TYP_DIM 
  where service_type_id = 134469888 and valid_from_tsp not like '2014-02-06 %'
  </code></pre>
  
  <p>When I run this query, I am returned the error: <code>Partial String matching requires character operands</code></p>
  
  <p>Upon searching this error, I was given <code>The user used the partial string matching operator (LIKE) with an argument that was not a character string.</code></p>
  
  <p>So what can I use to match a date? <strong>edit:</strong> or in this case, not a date?</p>