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

Add local timezone support to cqlsh

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Low
    • Resolution: Fixed
    • 2.2.6, 3.0.4, 3.4
    • None
    • 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

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            spod Stefan Podkowinski Assign to me
            srai Suleman Rai
            Stefan Podkowinski
            Paulo Motta (Deprecated)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment