Hi,
Have tried removing your dateOf calls and only inserting now()? Cheers, Jens On Thu, Sep 18, 2014 at 8:13 PM, Check Peck <comptechge...@gmail.com> wrote: > 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?
