python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - cassandra-4.0

How to add plus 1 day to a timestamp in Cassandra SQL?

I am trying to add 1 day to a timestamp field. Below is what I have tried but not working: select studentid, (course_date + 1) as nextday from students where studentid=123; select studentid,(course_da...
test-img

Divya Sam

cassandra

cql

cassandra-4.0

Votes: 0

Answers: 1

Latest Answer

Yes, you can specify a time component along with the date arithmetic. In this case, changing 1 to 1d (one day) solves this: > SELECT studentid,course_date + 1d as nextday FROM students WHERE stude...
test-img

Aaron

Posts

Questions

Blogs

Jobs