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

Benjamin Lerer commented on CASSANDRA-11873:
--------------------------------------------

One interesting question is what type of text representation do we want to 
support for duration.
The simplest approach would be to support only a number and a time unit: days 
({{d}}), hours ({{h}}), minutes ({{m}}), seconds ({{s}}), milliseconds ({{ms}}) 
and micro seconds ({{µs}}).
A slightly more complex one would be to allow the combination of multiple 
simple expressions like: 2d8h (2 days and 8 hours).

> Add duration type
> -----------------
>
>                 Key: CASSANDRA-11873
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11873
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: CQL
>            Reporter: Benjamin Lerer
>            Assignee: Benjamin Lerer
>             Fix For: 3.x
>
>
> For CASSANDRA-11871 or to allow queries with {{WHERE}} clause like:
> {{... WHERE reading_time < now() - 2h}}, we need to support some duration 
> type.
> In my opinion, it should be represented internally as a number of 
> microseconds.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to