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

Description

Conversions

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

Logical

Perform logical operations

Mathematical

Perform calculations based on input values provided as parameters to the functions, and return numeric values

String

Perform operations on a string (char or varchar) input value and return a string or numeric value.