Conversion Functions

This section contains the reference documentation for the Conversion functions built into Splice Machine SQL, in the following topics:

Function Name Description
BIGINT Returns a 64-bit integer representation of a number or character string in the form of an integer constant.
CAST Converts a value from one data type to another and provides a data type to a dynamic parameter (?) or a NULL value.
CHAR Returns a fixed-length character string representation.
DOUBLE Returns a floating-point number
INTEGER Returns an integer representation of a number or character string in the form of an integer constant.
SMALLINT Returns a small integer representation of a number or character string in the form of a small integer constant.
TO_CHAR Formats a date value into a string.
TO_DATE Formats a date string according to a formatting specification, and returns a date value.
VARCHAR Returns a varying-length character string representation of a character string.