not a support question
sanamana
Member
Hi,
I am cassandra novice and I am trying to come up to speed. When I ran CQL query, I got this for one of the columns "status, value=CREATED, timestamp=1340385863990010, ttl=604800000".
The timestamp attribute is there for every column. However, I am not sure how to convert the timestamp value to date. When I use java.util.Date and provide the value 1340385863990010, I get a date which is not quite correct. Can you tell me if this value is in milliseconds or microseconds or some other metric?
Timestamps are specified by the client so it depends on your client what format they are in. Traditionally clients use microseconds when specifying the timestamp. That is likely what your client is using.
sanamana,
Yeah, that timestamp corresponds to 2012-06-22 17:24:23 UTC if it's the typical "microseconds since the Epoch" used for column timestamps, which is a perfectly sane value.
However, it's not generally good practice to make use of column timestamps in your application code. You might want to consider using columns with the actual 'timestamp' or 'timeuuid' CQL data types instead, if you want to associate specific timestamps with other data.
