Updated on 2025-09-05 GMT+08:00

Arithmetic Functions

The following table lists the arithmetic functions supported by SecMaster SQL syntax.

Table 1 Arithmetic functions supported by SecMaster SQL syntax

Function

Function Description

+ numeric

Returns a numeric.

- numeric

Returns the opposite of a numeric.

numeric1 + numeric2

Returns the sum of numeric1 and numeric2.

numeric1 - numeric2

Returns the result of numeric1 minus numeric2.

numeric1 * numberic2

Returns the product of numeric1 and numeric2.

numeric1 / numeric2

Returns the quotient of numeric1 divided by numeric2.

UUID()

Returns a universally unique identifier (UUID) string based on RFC 4122 type 4 (pseudo-random generated). For example, 3d3c68f7-f608-473f-b60c-b0c44ad4cc4e is generated using a cryptographically strong pseudo-random number generator.