Cinchy Supported Functions covers the following topics:
Cinchy functions and Cinchy User defined functions are used in conjunction with Cinchy DML and DDL statements. Cinchy System Values are specific to the Cinchy platform similar to Cinchy functions. Cinchy User Defined Functions are split into Table-Valued Functions and Scalar-valued functions.
Scalar functions operate on a single value and return a single value. Scalar functions are composed of:
Support data type casting and converting
Perform operations on a date/time input values and return string, numeric, or date and time values
Perform logical operations
Perform calculations based on input values provided as parameters to the functions, and return numeric values
Perform operations on a string (char or varchar) input value and return a string or numeric value.