Skip to main content

Type Conversion

TOASCII

​​❌ Cannot be used in filter queries

Converts the input buffer (binary content, file contents) value into the ASCII character set (Base64 encoding).

Syntax

TOASCII(value)

NameTypeDescription
valuemandatoryThe buffer content to convert to the ASCII character set. The argument can be any valid expression that resolves to a buffer value (file contents object).

TOBOOLEAN

​​✔️ Safe to use in filter queries

Converts the input value to a boolean.

Syntax

TOBOOLEAN(value)

NameTypeDescription
valuemandatoryThe value to convert to boolean. The argument can be any valid expression that resolves to a value.

TODATE

​​✔️ Safe to use in filter queries

Converts the input value to a date. Raises an error if the input value is not a date.

Syntax

TODATE(value)

NameTypeDescription
valuemandatoryThe value to convert to date. The argument can be any valid expression that resolves to a value.

TODECIMAL

​​✔️ Safe to use in filter queries

Converts the input value to a decimal. Raises an error if the input value is not a decimal.

Syntax

TODECIMAL(value)

NameTypeDescription
valuemandatoryThe value to convert to decimal. The argument can be any valid expression that resolves to a value.

TOINTEGER

​​✔️ Safe to use in filter queries

Converts the input value to an integer. Raises an error if the input value is not an integer.

Syntax

TOINTEGER(value)

NameTypeDescription
valuemandatoryThe value to convert to integer. The argument can be any valid expression that resolves to a value.

TOTEXT

​​✔️ Safe to use in filter queries

Converts the input value to text.

Syntax

TOTEXT(value)

NameTypeDescription
valuemandatoryThe value to convert to text. The argument can be any valid expression that resolves to a value.