I have a Cassandra cluster version as - cqlsh:dataks> show version; [cqlsh 2.3.0 | Cassandra 2.0.6 | CQL spec 3.0.0 | Thrift protocol 19.39.0]
And I have a table like this - CREATE TABLE data_test ( valid_id int, data_id text, client_name text, creation_date timestamp, last_modified_date timestamp, PRIMARY KEY (valid_id, data_id) ) I am inserting the data like this in my above table - insert into data_test (valid_id, data_id, client_name, creation_date, last_modified_date) values (1, 'b4b61aa', 'TTLAP', dateOf(now()), dateOf(now())); After I do a select on my table, I am seeing creation_date and last_modified_date coming in some other format, not sure why? valid_id | data_id | client_name | creation_date | last_modified_date ----------+---------------------------------------------------------------------------------------- 1 | b4b61aa | TTLAP | \x00\x00\x01H\x89\xf0\xb6I | \x00\x00\x01H\x89\xf0\xb6I Does anyone know why creation_date and last_modified_date is coming like this and how we can get actual timestamp in those columns?