Scalar FunctionsType Functions

tobool

Convert the input to a boolean.

Syntax

tobool(value)

Prop

Type

Returns: bool

print tobool(1)

print_0 (bool)
true

print tobool("true")

print_0 (bool)
true

to_numeric

Extract numeric value from dynamic or pass through numeric types. Non-numeric values become null.

todouble

Convert the input to a floating point number.