You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Stefania (JIRA)" <ji...@apache.org> on 2016/02/19 01:56:18 UTC

[jira] [Reopened] (CASSANDRA-10397) Add local timezone support to cqlsh

     [ https://issues.apache.org/jira/browse/CASSANDRA-10397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Stefania reopened CASSANDRA-10397:
----------------------------------

> Add local timezone support to cqlsh
> -----------------------------------
>
>                 Key: CASSANDRA-10397
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10397
>             Project: Cassandra
>          Issue Type: Improvement
>         Environment: Ubuntu 14.04 LTS
>            Reporter: Suleman Rai
>            Assignee: Stefan Podkowinski
>            Priority: Minor
>              Labels: cqlsh
>             Fix For: 2.2.6, 3.0.4, 3.4
>
>         Attachments: sub_precision_fix_trunk.diff
>
>
> 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
(v6.3.4#6332)