[CASSANDRA-10397] Add local timezone support to cqlsh

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.2.6, 3.0.4, 3.4
• Labels: cqlsh

Environment

Ubuntu 14.04 LTS

• Assignee: Stefan Podkowinski
• Reporter: Suleman Rai

Authors

Stefan Podkowinski

Reviewers

Paulo Motta

• Created: 25/Sep/15 13:07
• Updated: 16/Apr/19 09:30
• Resolved: 19/Feb/16 19:45

Description

CQLSH is not 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.

Issue Links

• breaks: CASSANDRA-11184 cqlsh_tests.py:TestCqlsh.test_sub_second_precision is failing
• breaks: CASSANDRA-11185 cqlsh_copy_tests.py:CqlshCopyTest.test_round_trip_with_sub_second_precision is failing
• duplicates: CASSANDRA-10313 cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest.test_all_datatypes_read fails locally
• relates to: CASSANDRA-10415 Fix cqlsh bugs
• links to: CASSANDRA-10397-2.2