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?

Reply via email to