I am particularly interested in the format function. Also, if it is easy, I would love to see all the supported functions in one place?

QODBC Numeric Functions
The following Numeric Functions can be used in QODBC to obtain various results in your SQL statements:-

ABS(numeric_exp) – Returns the absolute value of numeric_exp.

Example:

SELECT "Name", {fn ABS(Balance)} AS "ABSBalance", "Balance" FROM Customer

Returns:

ACOS(float_exp) – Returns the arccosine of float_exp as an angle, expressed in radians.

Example:

SELECT {fn ACOS({fn CONVERT(0, SQL_FLOAT)})} AS "ACOSValue" FROM Company

Returns:

ASIN(float_exp) – Returns the arcsine of float_exp as an angle, expressed in radians.

Example:

SELECT {fn ASIN({fn CONVERT(1, SQL_FLOAT)})} AS "ASINValue" FROM Company

Returns:

ATAN(float_exp) – Returns the arctangent of float_exp as an angle, expressed in radians.

Example:

SELECT {fn ATAN({fn CONVERT(1, SQL_FLOAT)})} AS "ATANValue" FROM Company

Returns:

ATAN2(float_exp1, float_exp2) – Returns the arctangent of the x and y coordinates specified by float_exp1 and float_exp2, respectively, as an angle, expressed in radians.

Example:

SELECT {fn ATAN2({fn CONVERT(1, SQL_FLOAT)}, {fn CONVERT(2, SQL_FLOAT)})} AS "ATAN2Value" FROM Company

Returns:

CEILING(numeric_exp) – Returns the smallest integer greater than or equal to numeric_exp.

Example:

SELECT "Name", {fn CEILING("Balance")} AS "CeilingBalance", "Balance" FROM Customer

Returns:

COS(float_exp) – Returns the cosine of float_exp, where float_exp is an angle  expressed in radians.

Example:

SELECT {fn COS({fn CONVERT(1, SQL_FLOAT)})} AS "COSValue" FROM Company

Returns:

COT(float_exp) – Returns the cotangent of float_exp, where float_exp is an angle  expressed in radians.

Example:

SELECT {fn COT({fn CONVERT(1, SQL_FLOAT)})} AS "COTValue" FROM Company

Returns:

DEGREES(numeric_exp) – Returns the number of degrees converted from numeric_exp radians.

Example:

SELECT {fn DEGREES(1)} AS "DegreesReturned" FROM Company

Returns:

EXP(float_exp) – Returns the exponential value of float_exp.

Example:

SELECT {fn EXP({fn CONVERT(1, SQL_FLOAT)})} AS "ExpReturned" FROM Company

Returns:

FLOOR(numeric_exp) – Returns largest integer less than or equal to numeric_exp.

Example:

SELECT "Name", {fn FLOOR("Balance")} AS "FloorBalance", "Balance" FROM Customer

Returns:

LOG(float_exp) – Returns the natural logarithm of float_exp.

Example:

SELECT {fn LOG({fn CONVERT(25, SQL_FLOAT)})} AS "LogReturned" FROM Company

Returns:

LOG10(float_exp) – Returns the base 10 logarithm of float_exp.

Example:

SELECT {fn LOG10({fn CONVERT(25, SQL_FLOAT)})} AS "Log10Returned" FROM Company

Returns:

MOD(integer_exp1, integer_exp2) – Returns the remainder (modulus) of integer_exp1 divided by integer_exp2.

Example:

SELECT {fn MOD(27, 7)} AS "Mod7Returned" FROM Company

Returns:

PI() – Returns the constant value of pi as a floating point value.

Example:

SELECT {fn PI()} AS "PI" FROM COMPANY

Returns:

POWER(numeric_exp, integer_exp) – Returns the value of numeric_exp to the power of integer_exp.

Example:

SELECT {fn POWER(4, 3)} AS "PowerValue" FROM COMPANY

Returns:

RADIANS(numeric_exp) – Returns the number of radians converted from numeric_exp degrees.

Example:

SELECT {fn RADIANS(57.29578)} AS "RadiansValue" FROM COMPANY

Returns:

RAND([integer_exp]) – Returns a random floating point value using integer_exp as optional seed value.

Example:

SELECT {fn RAND()} AS "RandValue" FROM COMPANY

Returns:

ROUND(numeric_exp, integer_exp) – Returns numeric_exp rounded to integer_exp places right of the decimal point. If integer_exp is negative, numeric_exp is rounded to |integer_exp| places to the left of the decimal point.

Example:

SELECT "Name", {fn ROUND(Balance, 1)} AS "RoundBalance", "Balance" FROM Customer

Returns:

SIGN(numeric_exp) – Returns an indicator or the sign of numeric_exp. If numeric_exp is less than zero, -1 is returned. If numeric_exp equals zero, 0 is returned. If numeric_exp is greater than zero, 1 is returned.

Example:

SELECT "Name", {fn SIGN(Balance)} AS "SignOfBalance", "Balance" FROM Customer

Returns:

SIN(float_exp) – Returns the sine of float_exp, where float_exp is an angle  expressed in radians.

Example:

SELECT {fn SIN({fn CONVERT(1, SQL_FLOAT)})} AS "SINValue" FROM Company

Returns:

SQRT(float_exp) – Returns the square root of float_exp.

Example:

SELECT {fn SQRT({fn CONVERT(47, SQL_FLOAT)})} AS "SQRTValue" FROM Company

Returns:

TAN(float_exp) – Returns the tangent of float_exp, where float_exp is an angle  expressed in radians.

Example:

SELECT {fn TAN({fn CONVERT(1, SQL_FLOAT)})} AS "TANValue" FROM Company

Returns:

TRUNCATE(numeric_exp, integer_exp) – Returns numeric_exp truncated to integer_exp places right of the decimal point. If integer_exp is negative, numeric_exp is truncated to |integer_exp| places to the left of the decimal point.

Example:

SELECT "Name", {fn TRUNCATE(Balance, 1)} AS "TruncateBalance", "Balance" FROM Customer

Returns:

For more functions click here.