Built-in functions in Amazon Keyspaces

Amazon Keyspaces (for Apache Cassandra) supports a variety of built-in functions that you can use in Cassandra Query Language (CQL) statements.

Scalar functions

A scalar function performs a calculation on a single value and returns the result as a single value. Amazon Keyspaces supports the following scalar functions.

Function	Description
blobAsType	Returns a value of the specified data type.
cast	Converts one native data type into another native data type.
currentDate	Returns the current date/time as a date.
currentTime	Returns the current date/time as a time.
currentTimestamp	Returns the current date/time as a timestamp.
currentTimeUUID	Returns the current date/time as a timeuuid.
fromJson	Converts the JSON string into the selected column's data type.
maxTimeuuid	Returns the largest possible timeuuid for timestamp or date string.
minTimeuuid	Returns the smallest possible timeuuid for timestamp or date string.
now	Returns a new unique timeuuid. Supported for INSERT, UPDATE, and DELETE statements, and as part of the WHERE clause in SELECT statements.
toDate	Converts either a timeuuid or a timestamp to a date type.
toJson	Returns the column value of the selected column in JSON format.
token	Returns the hash value of the partition key.
toTimestamp	Converts either a timeuuid or a date to a timestamp.
TTL	Returns the expiration time in seconds for a column.
typeAsBlob	Converts the specified data type into a blob.
toUnixTimestamp	Converts either a timeuuid or a timestamp into a bigInt.
uuid	Returns a random version 4 UUID. Supported for INSERT, UPDATE, and DELETE statements, and as part of the WHERE clause in SELECT statements.
writetime	Returns the timestamp of the value of the specified column.
dateOf	(Deprecated) Extracts the timestamp of a timeuuid, and returns the value as a date.
unixTimestampOf	(Deprecated) Extracts the timestamp of a timeuuid, and returns the value as a raw, 64-bit integer timestamp.