format(X;Y)

Applies a format string to an input column or value.

Syntax

format(X;Y)

Input

Argument Type Description
X any The column or value to which the format string Y is applied.
Y text The format string to apply to X

Return Value

Returns a text value resulting from the application of the format string to the input column or value.

Example

The following example demonstrates the behavior of format(X;Y) as applied to an integer value.

format(123456789;'type:num;dec:5')