trying to figure out if i'm doing something wrong or a bug. i am creating a simple schema, inserting a timestamp using ISO8601 format, but when retrieving the timestamp, the timezone is displayed incorrectly. i'm inserting using GMT, the result is shown with "+0000", but the time is for my local timezone (-0800)
tried with 1.1.6 (DSE 2.2.1), and 1.2.0-rc1-SNAPSHOT here's the trace: bin/cqlsh Connected to Test Cluster at localhost:9160. [cqlsh 2.3.0 | Cassandra 1.2.0-rc1-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.35.0] Use HELP for help. cqlsh> CREATE KEYSPACE btoddb WITH replication = {'class':'SimpleStrategy', 'replication_factor':1}; cqlsh> cqlsh> USE btoddb; cqlsh:btoddb> CREATE TABLE test ( ... id uuid PRIMARY KEY, ... ts TIMESTAMP ... ); cqlsh:btoddb> cqlsh:btoddb> INSERT INTO test ... (id, ts) ... values ( ... '89d09c88-40ac-11e2-a1e2-6067201fae78', ... '2012-12-07T10:00:00-0000' ... ); cqlsh:btoddb> cqlsh:btoddb> SELECT * FROM test; id | ts --------------------------------------+-------------------------- 89d09c88-40ac-11e2-a1e2-6067201fae78 | 2012-12-07 02:00:00+0000 cqlsh:btoddb>