CQL equivalent of: select SYSTIMESTAMP from dual;?

Question

How can I get current systime on Cassandra using DevCenter.

SQL: select SYSTIMESTAMP from dual;

CQL: ?

Ashraful Islam · Accepted Answer · 2017-05-22T13:13:52.790

7

Try this

SELECT now() FROM system.local;

edited May 22 '17 at 13:13

answered May 22 '17 at 11:56

Ashraful Islam

No luck, schema_keyspaces does not exist, in my setup. – shrm May 22 '17 at 12:48
Try `SELECT now() FROM system.local;` – Ashraful Islam May 22 '17 at 13:14
Note that `now()` returns a [timeuuid](https://docs.datastax.com/en/dse/5.1/cql/cql/cql_reference/refDataTypes.html#refDataTypes__timeuuid). If you want a more traditional date type, you'll need to convert it, e.g. `system.totimestamp(now())` – M. Justin Nov 16 '20 at 20:41

score -1 · Answer 2 · answered May 22 '17 at 11:37

-1

I think Cassandra uses now():

select now()
. . .

answered May 22 '17 at 11:37

Gordon Linoff

1

select now() from _what_ ? – shrm May 22 '17 at 11:46
1

If you are doing from DevCenter. Pick keyspace **system**. Afterwards try with this line of code: `SELECT dateof(now()) FROM system.local;` – iMajna Jun 04 '17 at 15:21

2 Answers2