title: CQL timeuuid comparison using maxTimeuuid / minTimeuuid
body: <p>I am using Datastax cassandra distribution on Mac OS X (dsc-cassandra-1.2.6). I want to use timeuuid types, and was experimenting with queries against them.</p>
  
  <p>Here is my table:</p>
  
  <pre><code>CREATE TABLE test_t (
    canon_key text,
    t timeuuid,
    PRIMARY KEY (canon_key, t)
  )
  </code></pre>
  
  <p>Now lets say I get a row.</p>
  
  <pre><code>cqlsh:pagedb&gt; select canon_key, t, dateOf(t), unixTimestampOf(t) from test_t where canon_key = 'xxx' and t &gt;= minTimeuuid('2013-08-08 18:43:58-0700');                 
   canon_key | t                                    | dateOf(t)                | unixTimestampOf(t)
  
  -----------+--------------------------------------+--------------------------+--------------------
  
         xxx | 287d3c30-0095-11e3-9268-a7d2e09193eb | 2013-08-08 18:43:58-0700 |      1376012638067
  </code></pre>
  
  <p>Now, I want to delete this row. I don't see a good way of doing it, because there is no equality operator for the timeuuid type.</p>
  
  <p>The nature of the data I am adding is such that I (possibly) wouldn't even mind doing this:</p>
  
  <p><strong>cqlsh:pagedb> select canon_key, t, dateOf(t), unixTimestampOf(t) from test_t where canon_key = 'xxx' and t >= minTimeuuid('2013-08-08 18:43:58-0700') and t &lt;= maxTimeuuid('2013-08-08 18:43:58-0700');</strong></p>
  
  <p>But according to the documentation (<a href="http://cassandra.apache.org/doc/cql3/CQL.html#usingdates" rel="nofollow">http://cassandra.apache.org/doc/cql3/CQL.html#usingdates</a>), that will not work. Quoting: " Please note that t >= maxTimeuuid('2013-01-01 00:05+0000') would still not select a timeuuid generated exactly at ‘2013-01-01 00:05+0000’ and is essentially equivalent to t > maxTimeuuid('2013-01-01 00:05+0000').".</p>
  
  <p>So.. how do I delete this row?</p>