Juho Mäkinen created CASSANDRA-6973: ---------------------------------------
Summary: timestamp data type does ISO 8601 formats with 'Z' as time zone. Key: CASSANDRA-6973 URL: https://issues.apache.org/jira/browse/CASSANDRA-6973 Project: Cassandra Issue Type: Bug Components: Core Reporter: Juho Mäkinen Priority: Trivial Fix For: 2.0.6 The timestamp data type does not support format where time zone is specified with 'Z' (as in zulu aka. UTC+0 aka +0000 time zone). Example: create table foo(ts timestamp primary key); insert into foo(ts) values('2014-04-01T20:17:35+0000'); -- this works cqlsh:test> insert into foo(ts) values('2014-04-01T20:17:35Z'); Bad Request: unable to coerce '2014-04-01T20:17:35Z' to a formatted date (long) The example date was copied directly from ISO 8601 Wikipedia page. The standard says that "If the time is in UTC, add a Z directly after the time without a space. Z is the zone designator for the zero UTC offset." Tested with cqlsh with 2.0.6 version. -- This message was sent by Atlassian JIRA (v6.2#6252)