cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paulo Motta (JIRA)" <>
Subject [jira] [Commented] (CASSANDRA-10397) CQLSH not displaying correct timezone
Date Fri, 25 Sep 2015 18:46:04 GMT


Paulo Motta commented on CASSANDRA-10397:

we decided to change the default behavior of displaying dates on the local timezone, since
that was not working on Windows due to python limitations (an additional pytz library was
needed to provide that functionality).

we need to provide an option for users to change the default timezone from UTC to any other
timezone, provided they have the pytz (or some similar library) installed. Have you created
a ticket for that [~aploetz]? If not, we can use this ticket.

> CQLSH not displaying correct timezone
> -------------------------------------
>                 Key: CASSANDRA-10397
>                 URL:
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>         Environment: Ubuntu 14.04 LTS
>            Reporter: Suleman Rai
>              Labels: cqlsh
>             Fix For: 2.1.x, 2.2.x
> 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.

This message was sent by Atlassian JIRA

View raw message