doc/modules/cassandra/examples/CQL/currentdate.cql

SELECT * FROM myTable WHERE date >= currentDate() - 2d;