cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "B. Todd Burruss (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-5046) cqlsh doesn't show correct timezone when SELECTing a column of type TIMESTAMP
Date Sun, 09 Dec 2012 03:25:20 GMT
B. Todd Burruss created CASSANDRA-5046:
------------------------------------------

             Summary: cqlsh doesn't show correct timezone when SELECTing a column of type
TIMESTAMP
                 Key: CASSANDRA-5046
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5046
             Project: Cassandra
          Issue Type: Bug
    Affects Versions: 1.2.0 beta 3, 1.1.6
         Environment: cassandra 1.1.6 (DSE 2.2.1) or cassandra RC1 (from tip)
            Reporter: B. Todd Burruss
            Priority: Minor


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>

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message