title: How to get entries of a date greater then x date in Apache Phoenix
body: <p>I have a column activation_date in Phoenix of type Date, which contains entries like "<code>2016-06-18 07:00:00.000</code>",<br/> how do I do select on same for a date greater then x date:</p>
  
  <pre><code>select activation_date from xyz where activation_date &gt; '2017-03-17 07:00:00.000' limit 10;
  </code></pre>
  
  <p>Above query gives error like:</p>
  
  <blockquote>
    <p>Error: ERROR 203 (22005): Type mismatch. DATE and VARCHAR for
    USER_DATA.ACTIVATION_DATE > '2017-03-17 07:00:00.000'
    (state=22005,code=203)
    org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005):
    Type mismatch. DATE and VARCHAR for ACTIVATION_DATE > '2017-03-17
    07:00:00.000'</p>
  </blockquote>