Scalar FunctionsType Functions

asdatetime

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

Syntax

asdatetime(value)

Prop

Type

Returns: datetime

print asdatetime(dynamic(datetime(2026-01-01)))

print_0 (datetime)
2026-01-01T00:00:00Z

asbool

Extract a boolean from a dynamic or pass through a bool value. Other types become null.

asdouble

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