http://www.datastax.com/support-forums/topic/how-to-convert-timestamp-value-to-date Software, Support, and Training for Apache Cassandra en-US Thu, 23 May 2013 20:16:06 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/how-to-convert-timestamp-value-to-date#post-2953 Thu, 12 Jul 2012 04:14:17 +0000 thepaul 2953@http://www.datastax.com/support-forums/ <p>sanamana,</p> <p>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.</p> <p>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. </p> http://www.datastax.com/support-forums/topic/how-to-convert-timestamp-value-to-date#post-2905 Wed, 11 Jul 2012 02:52:09 +0000 nickmbailey 2905@http://www.datastax.com/support-forums/ <p>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. </p> http://www.datastax.com/support-forums/topic/how-to-convert-timestamp-value-to-date#post-2887 Tue, 10 Jul 2012 22:19:12 +0000 sanamana 2887@http://www.datastax.com/support-forums/ <p>Hi,</p> <p>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".</p> <p>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? </p>