Edit ~/.cassandra/cqlshrc
[ui]
time_format = %Y%m%d %H:%M:%S.%f
http://stackoverflow.com/questions/28547616/cassandra-cqlsh-how-to-show-microseconds-milliseconds-for-timestamp-columns http://docs.datastax.com/en/cql/3.1/cql/cql_reference/cqlsh.html https://docs.python.org/2/library/datetime.html#strftime-and-strptime-behavior