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

Reply via email to