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

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

    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

          People

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

            Dates

              Created:
              Updated:
              Resolved: