[CASSANDRA-9229] Add functions to convert timeuuid to date or time

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.2.0 rc2
• Component/s: Legacy/CQL
• Labels: cql
• Impacts: Docs
• Assignee: Benjamin Lerer
• Reporter: Michaël Figuière

Authors

Benjamin Lerer

Reviewers

Robert Stupp

• Created: 23/Apr/15 17:51
• Updated: 06/Nov/19 22:04
• Resolved: 11/Jun/15 08:21

Description

As CASSANDRA-7523 brings the date and time native types to Cassandra, it would be useful to add builtin function to convert timeuuid to these two new types, just like dateOf() is doing for timestamps.

timeOf() would extract the time component from a timeuuid. Example use case could be at insert time with for instance timeOf(now()), as well as at read time to compare the time component of a timeuuid column in a WHERE clause.

The use cases would be similar for date but the solution is slightly less obvious, as in a perfect world we would want dateOf() to convert to date and timestampOf() for timestamp, unfortunately dateOf() already exist and convert to a timestamp, not a date. Making this change would break many existing CQL queries which is not acceptable. Therefore we could use a different name formatting logic such as toDate or dateFrom. We could then also consider using this new name convention for the 3 dates related types and just have dateOf becoming a deprecated alias.