title: How to use where on timestamp column in vertica
body: <p>I am using vertica db and want to query  somthing like:</p>
  
  <pre><code>select count(*) from users where  create_ts ='2015-04-17 05:01:02'
  </code></pre>
  
  <p>where create_ts is timestamp . I am getting zero count however I am having many records.</p>