cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aleksey Yeschenko (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-5046) cqlsh doesn't show correct timezone when SELECTing a column of type TIMESTAMP
Date Mon, 10 Dec 2012 15:29:21 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-5046?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Aleksey Yeschenko updated CASSANDRA-5046:
-----------------------------------------

    Reviewer: jbellis  (was: brandon.williams)
    
> 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.1.6, 1.2.0 beta 3
>         Environment: cassandra 1.1.6 (DSE 2.2.1) or cassandra RC1 (from tip)
>            Reporter: B. Todd Burruss
>            Assignee: Aleksey Yeschenko
>            Priority: Minor
>             Fix For: 1.1.8, 1.2.0 rc1
>
>         Attachments: 5046-1.1.txt, 5046-1.2.txt
>
>
> 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