You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by "B. Todd Burruss" <bt...@gmail.com> on 2012/12/07 22:14:39 UTC
CQL timestamps and timezones
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>
Re: CQL timestamps and timezones
Posted by Bryan Talbot <bt...@aeriagames.com>.
With 1.1.5, the TS is displayed with the local timezone and seems correct.
cqlsh:bat> create table test (id uuid primary key, ts timestamp );
cqlsh:bat> insert into test (id,ts) values (
'89d09c88-40ac-11e2-a1e2-6067201fae78', '2012-12-07T10:00:00-0000');
cqlsh:bat> select * from test;
id | ts
--------------------------------------+--------------------------
89d09c88-40ac-11e2-a1e2-6067201fae78 | 2012-12-07 02:00:00-0800
cqlsh:bat>
-Bryan
On Fri, Dec 7, 2012 at 1:14 PM, B. Todd Burruss <bt...@gmail.com> wrote:
> 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>
>