[CASSANDRA-4746] cqlsh timestamp formatting is broken - displays wrong timezone info (at least on Ubuntu)

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 1.1.7, 1.2.0 beta 2
• Labels: cqlsh

Environment

64-bit Ubuntu 12.04, python 2.7.3

• Severity: Low
• Assignee: Aleksey Yeschenko
• Reporter: Aleksey Yeschenko

Authors

Aleksey Yeschenko

Reviewers

Brandon Williams

• Created: 02/Oct/12 02:09
• Updated: 16/Apr/19 09:32
• Resolved: 30/Oct/12 18:51

Description

cqlsh> create keyspace test with strategy_class = 'SimpleStrategy' AND strategy_options:replication_factor = 1;
cqlsh> use test;
cqlsh:test> create table ts (id int primary key, ts timestamp);
cqlsh:test> insert into ts (id, ts) values (1, '2012-05-14 07:53:20+0000');
cqlsh:test> select * from ts;
id | ts
---+-------------------------
1 | 2012-05-14 10:53:20+0000

Should've been 2012-05-14 10:53:20+0300.

cqlsh formats timestamps using '%Y-%m-%d %H:%M:%S%z' format-string and 'the %z escape that expands to the preferred hour/minute offset is not supported by all ANSI C libraries'. In this case it's just replaced with all zeroes.

Issue Links

• is duplicated by: CASSANDRA-4437 cqlsh displays bad timezone for timestamp types