title: Cassandra: Unable to coerce '2016-04-06 13:06:11.534000' to a formatted date (long)
body: <p>I am trying to UPDATE an existing item in my cassandra DB using cqlsh:</p>
  
  <pre><code>$ &gt; UPDATE allEvents SET "isLastEvent" = True WHERE "websiteId" = 'sd-8231'
  AND "purchaser" = False
  AND "currentTime" = '2016-04-06 13:06:11.534000';
  </code></pre>
  
  <p>And I got this:</p>
  
  <blockquote>
    <p>InvalidRequest: code=2200 [Invalid query] message="Unable to coerce '2016-04-06 13:06:11.534000' to a formatted date (long)"</p>
  </blockquote>
  
  <p>In case it can help:</p>
  
  <pre><code>$ &gt; show version
  [cqlsh 5.0.1 | Cassandra 3.0.2 | CQL spec 3.3.1 | Native protocol v4]
  </code></pre>