Suleman Rai created CASSANDRA-10397: ---------------------------------------
Summary: CQLSH not displaying correct timezone Key: CASSANDRA-10397 URL: https://issues.apache.org/jira/browse/CASSANDRA-10397 Project: Cassandra Issue Type: Bug Components: Core Environment: Ubuntu 14.04 LTS Reporter: Suleman Rai Priority: Blocker Fix For: 2.1.x, 2.2.x CQLSH is adding the timezone offset to the timestamp after it has been inserted into a table. create table test(id int PRIMARY KEY, time timestamp); INSERT INTO test(id,time) values (1,dateof(now())); select *from test; id | time ----+--------------------- 1 | 2015-09-25 13:00:32 It is just displaying the default UTC timestamp without adding the timezone offset. It should be 2015-09-25 21:00:32 in my case as my timezone offset is +0800. -- This message was sent by Atlassian JIRA (v6.3.4#6332)