Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-10397

Add local timezone support to cqlsh

    XMLWordPrintableJSON

    Details

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

      Ubuntu 14.04 LTS

      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.

        Attachments

        1. sub_precision_fix_trunk.diff
          1 kB
          Stefania Alborghetti

          Issue Links

            Activity

              People

              • Assignee:
                spod Stefan Podkowinski
                Reporter:
                srai Suleman Rai
                Authors:
                Stefan Podkowinski
                Reviewers:
                Paulo Motta (Deprecated)
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: