Cinchy Supported Functions

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:

Function Category



Support data type casting and converting

Date and Time Date Types

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.