[CASSANDRA-11137] JSON datetime formatting needs timezone

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.2.7, 3.0.6, 3.6
• Component/s: Legacy/CQL
• Severity: Normal
• Assignee: Alex Petrov
• Reporter: Stefania Alborghetti

Authors

Alex Petrov

Reviewers

Stefania Alborghetti

• Created: 09/Feb/16 00:54
• Updated: 16/Apr/19 09:30
• Resolved: 27/Apr/16 09:18

Description

The JSON date time string representation lacks the timezone information:

cqlsh:events> select toJson(created_at) AS created_at from event_by_user_timestamp ;

 created_at
---------------------------
 "2016-01-04 16:05:47.123"

(1 rows)

vs.

cqlsh:events> select created_at FROM event_by_user_timestamp ;

 created_at
--------------------------
 2016-01-04 15:05:47+0000

(1 rows)
cqlsh:events>

To make things even more complicated the JSON timestamp is not returned in UTC.

At the moment DateType picks this formatting string "yyyy-MM-dd HH:mm:ss.SSS". Shouldn't we somehow make this configurable by users or at a minimum add the timezone?