Re: How to select timestamp with CQL

2013-10-23 Thread Laing, Michael
http://www.datastax.com/documentation/cql/3.1/webhelp/index.html#cql/cql_reference/select_r.html On Wed, Oct 23, 2013 at 6:50 AM, Alex N wrote: > Thanks! > I can't find it in the documentation... > > > > 2013/10/23 Cyril Scetbon > >> Hi, >> >> Now you can ask for the TTL and the TIMESTAMP as s

Re: How to select timestamp with CQL

2013-10-23 Thread Alex N
Thanks! I can't find it in the documentation... 2013/10/23 Cyril Scetbon > Hi, > > Now you can ask for the TTL and the TIMESTAMP as shown in the following > example : > > cqlsh:k1> select * FROM t1 ; > > *ise*| *filtre* | *value_1* > ++- > *cyril1* | *2* |

Re: How to select timestamp with CQL

2013-10-23 Thread Cyril Scetbon
Hi, Now you can ask for the TTL and the TIMESTAMP as shown in the following example : cqlsh:k1> select * FROM t1 ; ise| filtre | value_1 ++- cyril1 | 2 | 49926 cyril2 | 1 | 18584 cyril3 | 2 | 31415 cqlsh:k1> select filtre,writetime(filtre),t