[CASSANDRA-17029] Add unix time conversion functions

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 4.1-alpha1, 4.1
• Component/s: CQL/Syntax
• Change Category: Semantic
• Complexity: Low Hanging Fruit
• Platform: All

Source Control Link

https://github.com/apache/cassandra/commit/8ddcd43b0cfcebfda882a238532d00905fe85eb8

Test and Documentation Plan

https://github.com/apache/cassandra/pull/1275

• Assignee: Kanthi Subramanian
• Reporter: Benjamin Lerer

Authors

Kanthi Subramanian

Reviewers

Benjamin Lerer, Brandon Williams

• Mentor: Benjamin Lerer
• Created: 08/Oct/21 16:06
• Updated: 27/May/22 19:24
• Resolved: 09/Nov/21 13:19

Description

It will be useful to have some functions to conver unix time values into C* native types, like:

• toDate(bigint)
• toTimestamp(bigint)
• mintimeuuid(bigint)
• maxtimeuuid(bigint)

Additional info for newcomers:

Those new functions need to be added to org.apache.cassandra.cql3.functions.TimeFcts and some unit tests need to be added to org.apache.cassandra.cql3.functions..TimeFctsTest. The other functions in TimeFcts provide some good example of how to create new functions.
As it is a new functionality they need to be mentioned in the NEWS.txt file.

Issue Links

• causes: CASSANDRA-17133 Broken test_timeuuid - upgrade_tests.cql_tests