title: Cassandra cqlsh - how to show microseconds/milliseconds for timestamp columns?
body: <p>I'm inserting into a Cassandra table with timestamp columns. The data I have comes with microsecond precision, so the time data string looks like this:</p>
  
  <p><strong>2015-02-16T18:00:03.234+00:00</strong></p>
  
  <p>However, in cqlsh when I run a select query the microsecond data is not shown, I can only see time down to second precision. The <strong>234</strong> microseconds data is not shown.</p>
  
  <p>I guess I have two questions:</p>
  
  <p>1) Does Cassandra capture microseconds with timestamp data type? My guess is yes?</p>
  
  <p>2) How can I see that with cqlsh to verify? </p>
  
  <p>Table definition:</p>
  
  <pre><code>create table data (
    datetime timestamp,
    id text,
    type text,
    data text,
    primary key (id, type, datetime)
  ) 
  with compaction = {'class' : 'DateTieredCompactionStrategy'};
  </code></pre>
  
  <p>Insert query ran with Java PreparedStatment:</p>
  
  <pre><code>insert into data (datetime, id, type, data) values(?, ?, ?, ?);
  </code></pre>
  
  <p>Select query was simply:</p>
  
  <pre><code>select * from data;
  </code></pre>