A Cassnadra table contains a timestamp, which specifies the time that a write occurred to a column. You can get this timestamp value Using the WRITETIME function. WRITETIME function returns the time in microseconds.
Previous
Next
Homecqlsh> SELECT * FROM cassandratutorial.employee;
id | age | firstname | lastname
----+-----+-----------+----------
1 | 31 | Hari | Gurram
2 | 31 | Ram | Gurram
3 | 33 | Ram | Ponnam
(3 rows)
cqlsh>
cqlsh> SELECT id, WRITETIME(firstname) FROM cassandratutorial.employee;
id | writetime(firstname)
----+----------------------
1 | 1555393882415773
2 | 1555392702737296
3 | 1555394042089780
(3 rows)
No comments:
Post a Comment