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

cqlsh doesn't show correct timezone when SELECTing a column of type TIMESTAMP

Log workAgile BoardRank to TopRank to BottomAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Low
    • Resolution: Fixed
    • 1.1.8, 1.2.0 rc1
    • None
    • None
    • cassandra 1.1.6 (DSE 2.2.1) or cassandra RC1 (from tip)

    • Low

    Description

      trying to figure out if i'm doing something wrong or a bug. i am
      creating a simple schema, inserting a timestamp using ISO8601 format,
      but when retrieving the timestamp, the timezone is displayed
      incorrectly. i'm inserting using GMT, the result is shown with
      "+0000", but the time is for my local timezone (-0800)

      tried with 1.1.6 (DSE 2.2.1), and 1.2.0-rc1-SNAPSHOT

      here's the trace:

      bin/cqlsh
      Connected to Test Cluster at localhost:9160.
      [cqlsh 2.3.0 | Cassandra 1.2.0-rc1-SNAPSHOT | CQL spec 3.0.0 | Thrift
      protocol 19.35.0]
      Use HELP for help.
      cqlsh> CREATE KEYSPACE btoddb WITH replication =

      {'class':'SimpleStrategy', 'replication_factor':1}

      ;
      cqlsh>
      cqlsh> USE btoddb;
      cqlsh:btoddb> CREATE TABLE test (
      ... id uuid PRIMARY KEY,
      ... ts TIMESTAMP
      ... );
      cqlsh:btoddb>
      cqlsh:btoddb> INSERT INTO test
      ... (id, ts)
      ... values (
      ... '89d09c88-40ac-11e2-a1e2-6067201fae78',
      ... '2012-12-07T10:00:00-0000'
      ... );
      cqlsh:btoddb>
      cqlsh:btoddb> SELECT * FROM test;

      id | ts
      -------------------------------------+-------------------------
      89d09c88-40ac-11e2-a1e2-6067201fae78 | 2012-12-07 02:00:00+0000

      cqlsh:btoddb>

      Attachments

        1. 5046-1.1.txt
          0.6 kB
          Aleksey Yeschenko
        2. 5046-1.2.txt
          0.6 kB
          Aleksey Yeschenko

        Activity

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

          People

            aleksey Aleksey Yeschenko Assign to me
            btoddb B. Todd Burruss
            Aleksey Yeschenko
            Jonathan Ellis
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment