Data Types

Supported data types and conversion variants between them

Available conversions

Functions	String	Integer	Decimal	Boolean	DateTime	Date	Time	Array	Object
To -> String	-	ToString()	ToString()	ToString()	ToString()	ToString()	ToString()	ToString()	ToString()
To -> Integer	ToInt(format)	-	ToInt() = Trunc()	ToInt()	ToInt()	ToInt()	ToInt()	No	No
To -> Decimal	ToDecimal(format)	ToDecimal()	-	ToDecimal()	ToDecimal()	ToDecimal()	ToDecimal()	No	No
To -> Boolean	ToBool()	ToBool()	ToBool()	-	No	No	No	No	No
To -> DateTime	ToDateTime(format)	No	No	No	-	ToDateTime()	No	No	No
To -> Date	ToDate(format)	No	No	No	ToDate()	-	No	No	No
To -> Time	ToTime(format)	No	No	No	ToTime()	No	-	No	No
To -> Array	ToArray()	ToArray()	ToArray()	ToArray()	ToArray()	ToArray()	ToArray()	-	ToArray()
To -> Object	ToObject()	ToObject()	ToObject()	ToObject()	ToObject()	ToObject()	ToObject()	ToObject()	-

As parameters for functions

if Yes then functions are working with this types as parameters, no Explicit conversion is needed

Functions	String	Integer	Decimal	Boolean	DateTime	Date	Time	Array	Object
Math functions	-	Yes	Yes	-	-	-	-	-	-
Window functions	-	Yes	Yes	By function	By function	By function	By function	-	-
Aggr -> Math	-	Yes	Yes	By function	By function	By function	By function	-	-
String	Yes	-	-	-	-	-	-	-	-
Regex	Yes	-	-	-	-	-	-	-	-
DateTime	-	-	-	-	Yes	Yes	Yes	-	-