[jira] [Issue Comment Edited] (CASSANDRA-3770) Timestamp datatype in CQL gets weird value?

["Rick Shaw (Issue Comment Edited) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-3770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13191504#comment-13191504 ] 

Rick Shaw edited comment on CASSANDRA-3770 at 1/23/12 9:47 PM:
---------------------------------------------------------------

As this is a data type for Java {{Date}}, please pass in a {{Date}} and not a {{long}}. It actually encodes it like a {{long}} but it's decompose method expecta a Java {{Date}} and its compose method produces a {{Date}}. You can, of course, use a {{long}} daatatype if you want to produce the long as in your explanation.

                
      was (Author: ardot):
    As this is a data tpye for Java {{Date}} please pass in a {{Date}} and not a {{long}}. It actually encodes it like a {{long}} but it's decompose method expecta a Java {{Date}} and its compose method produces a {{Date}}. You can, of course, use a {{long}} daatatype if you want to produce the long as in your explanation.

                  
> Timestamp datatype in CQL gets weird value?
> -------------------------------------------
>
>                 Key: CASSANDRA-3770
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3770
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: MacOS, Java
>            Reporter: Jawahar Prasad JP
>              Labels: cql, java
>
> Hi..
> I have created a columnfamily through CQL, having datatype as timestamp,
> I generate timestamp like this in Java:
> System.currentTimeMillis()
> (or)
> System.currentTimeMillis()*1000
> When I see the output through CQL, I get the data like below:
> 1.32725062505e+12
> Also, I am not able to use any operators against this (like > '01 January 2012' etc.,), I get the below error:
> No indexed columns present in by-columns clause with "equals" operator
> But, I have created an index for the timestamp column.
> Any help ?

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira