Why column with timestamp datatype come in different format?

2014-09-18 Thread Check Peck 
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?

Re: Why column with timestamp datatype come in different format?

2014-09-18 Thread Jens Rantil 
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?