Cassandra - How to get the Day of week from the timestamp column?

Question

I have a timestamp column in a Cassandra table, how do i get the day of week from the timestamp column using cql?

you can't do this in cql. you have to use java or other programming language to do this — Ashraful Islam, Mar 30 '17 at 09:48

score 3 · Accepted Answer · edited May 23 '17 at 12:17

There isn't support out of the box for this but

If using the CQL is a must you can have a look at the User Defined Functions:

Then you could use something as simple as:

or even something like

And then you have a UDF that gives you day of the week when you are working with a dates.

1 Answers1