looking for some solutions? You are welcome.

SOLVED: Setting Timezone for IntelliJ Cassandra Database Viewer


I'm writing some Java code interacting with Cassandra. I was wondering if there is any way to adjust the timezone for displaying (not for storing) columns of TIMESTAMP types.

A column of timestamp type

As far as I understand, Cassandra's TIMESTAMP type is essentially a number of milliseconds since the epoch[2], hence there is no notion of timezone for the type and the viewer shows the time as in UTC.

Here's what I have tried:

According to JetBrains documentation, there's a JVM option user.timezone to make this kind of adjustment. So I've set the JVM option of the Cassandra driver as -Duser.timezone=UTC+09:00, but it appears to have no effect whatsoever.

Is there any way to make the viewer to show the times in a different timezone?

Posted in S.E.F
via StackOverflow & StackExchange Atomic Web Robots

No comments: