Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of btalbot@aeriagames.com
 designates 74.125.149.201 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAH0yS3LCAG+tB9HtR581J7CHKLNFiV9_xrakfnqCBcSsqR_+Uw@mail.gmail.com>
References: 
 <CAH0yS3LCAG+tB9HtR581J7CHKLNFiV9_xrakfnqCBcSsqR_+Uw@mail.gmail.com>
Date: Fri, 7 Dec 2012 15:25:38 -0800
Message-ID: 
 <CAPmnz8GXaMwnb1DxT9wdRUZv7xiXiKfA--Zeaq+TAnYaQ2pgxQ@mail.gmail.com>
Subject: Re: CQL timestamps and timezones
From: Bryan Talbot <btalbot@aeriagames.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=00248c176b3481abe704d04b8806

--00248c176b3481abe704d04b8806
Content-Type: text/plain; charset=UTF-8

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 <btoddb@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>
>

--00248c176b3481abe704d04b8806
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

With 1.1.5, the TS is displayed with the local timezone and seems correct.<=
div><br></div><div><div>cqlsh:bat&gt; create table test (id uuid primary ke=
y, ts timestamp );</div><div>cqlsh:bat&gt; insert into test (id,ts) values =
( &#39;89d09c88-40ac-11e2-a1e2-6067201fae78&#39;, =C2=A0&#39;2012-12-07T10:=
00:00-0000&#39;);</div>
</div><div><div>cqlsh:bat&gt; select * from test;</div><div>=C2=A0id =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | ts</div><div>---------------------=
-----------------+--------------------------</div><div>=C2=A089d09c88-40ac-=
11e2-a1e2-6067201fae78 | 2012-12-07 02:00:00-0800</div>
<div><br></div><div>cqlsh:bat&gt;=C2=A0</div></div><div><br></div><div clas=
s=3D"gmail_extra"><br></div><div class=3D"gmail_extra">-Bryan</div><div cla=
ss=3D"gmail_extra"><br><br><div class=3D"gmail_quote">On Fri, Dec 7, 2012 a=
t 1:14 PM, B. Todd Burruss <span dir=3D"ltr">&lt;<a href=3D"mailto:btoddb@g=
mail.com" target=3D"_blank">btoddb@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">trying to figure out if i&#39;m doing someth=
ing wrong or a bug. =C2=A0i am<br>
creating a simple schema, inserting a timestamp using ISO8601 format,<br>
but when retrieving the timestamp, the timezone is displayed<br>
incorrectly. =C2=A0i&#39;m inserting using GMT, the result is shown with<br=
>
&quot;+0000&quot;, but the time is for my local timezone (-0800)<br>
<br>
tried with 1.1.6 (DSE 2.2.1), and 1.2.0-rc1-SNAPSHOT<br>
<br>
here&#39;s the trace:<br>
<br>
bin/cqlsh<br>
Connected to Test Cluster at localhost:9160.<br>
[cqlsh 2.3.0 | Cassandra 1.2.0-rc1-SNAPSHOT | CQL spec 3.0.0 | Thrift<br>
protocol 19.35.0]<br>
Use HELP for help.<br>
cqlsh&gt; CREATE KEYSPACE btoddb WITH replication =3D<br>
{&#39;class&#39;:&#39;SimpleStrategy&#39;, &#39;replication_factor&#39;:1};=
<br>
cqlsh&gt;<br>
cqlsh&gt; USE btoddb;<br>
cqlsh:btoddb&gt; CREATE TABLE test (<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ... =C2=A0 id uuid PRIMARY KEY,<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ... =C2=A0 ts TIMESTAMP<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ... );<br>
cqlsh:btoddb&gt;<br>
cqlsh:btoddb&gt; INSERT INTO test<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ... =C2=A0 (id, ts)<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ... =C2=A0 values (<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ... =C2=A0 =C2=A0 &#39;89d09c88-40ac-11e=
2-a1e2-6067201fae78&#39;,<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ... =C2=A0 =C2=A0 &#39;2012-12-07T10:00:=
00-0000&#39;<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ... =C2=A0 );<br>
cqlsh:btoddb&gt;<br>
cqlsh:btoddb&gt; SELECT * FROM test;<br>
<br>
=C2=A0id =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | ts<br>
--------------------------------------+--------------------------<br>
=C2=A089d09c88-40ac-11e2-a1e2-6067201fae78 | 2012-12-07 02:00:00+0000<br>
<br>
cqlsh:btoddb&gt;<br>
</blockquote></div><br>
</div>

--00248c176b3481abe704d04b8806--