Hello all, When I select a timestamp as JSON from Cassandra, the string representation lacks the timezone information, both via CQLSH and the Java Driver:
cqlsh:events> select toJson(created_at) AS created_at from event_by_patient_timestamp ; created_at --------------------------- "2016-01-04 16:05:47.123" (1 rows) vs. cqlsh:events> select created_at FROM event_by_user_timestamp ; created_at -------------------------- 2016-01-04 15:05:47+0000 (1 rows) cqlsh:events> To make things even more complicated the JSON timestamp is not returned in UTC. Is there a way to either tell the driver/C* to return the JSON date in UTC or add the timezone information (much preferred) to the text representation of the timestamp? Thanks! Ralf