Scalar FunctionsType Functions

asdouble

Extract a real from a dynamic or pass through an int/long/real value. Other types become null.

Syntax

asdouble(value)

Prop

Type

Returns: real

print asdouble(dynamic(3.15))

print_0 (real)
3.15

asdatetime

Extract a datetime from a dynamic or pass through a datetime value. Other types (including date strings) become null.

asint

Extract a 32-bit integer from a dynamic or pass through an int/long value. Other types (or out-of-range) become null.