[jira] [Commented] (CASSANDRA-7536) High resolution types for timestamp and time

["Sylvain Lebresne (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-7536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14084582#comment-14084582 ] 

Sylvain Lebresne commented on CASSANDRA-7536:
---------------------------------------------

A priori, I'm not convinced nanosecond resolution times are common enough in the wild that it's worth creeping up the CQL types.

> High resolution types for timestamp and time
> --------------------------------------------
>
>                 Key: CASSANDRA-7536
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7536
>             Project: Cassandra
>          Issue Type: New Feature
>            Reporter: Robert Stupp
>            Priority: Minor
>
> CASSANDRA-7523 adds support for _date_ and _time_ data types using the same precision as current _timestamp_ type.
> This ticket is about to add high resolution (nanosecond precision) types for timestamp and time. It should be easy to use with Joda API and Java 8 {{java.time}} API.
> Additionally support for time zone / offset (might need be handled differently) could be introduced using new time and timestamp types.
> Idea for binary serialization format (from java.time API):
> {{(int)year (short)month (short)day (byte)hour (byte)minute (byte)second (int)nano (int)offsetInSeconds}}
> Additional thinking is required to make even the time zone / offset types comparable (even for different TZ offsets) - so these might not be covered by this ticket.



--
This message was sent by Atlassian JIRA
(v6.2#6252)