Value Conversion Functions

Function	Description
Convert(source_value, target_type)	Converts a value to the specified type. Value types can be converted according to the type conversion table. The first argument is any expression to be converted. The second argument denotes a type to convert value to. Note that the functions can be applied to a vector (compound) value while the second argument denotes a scalar type. In this case conversion is applied to each element of the vector.
ToText(x)	Converts a value to text. A shortcut for Convert function call with second argument denoting text type.
ToInt(x)	Converts a value to integer numeric. A shortcut for Convert function call with second argument denoting integer type.
ToReal(x)	Converts a value to real (floating-point) numeric. A shortcut for Convert function call with second argument denoting real type.
ParseInt(source_value)	Parses an input text value and returns an integer value. If the conversion is not possible, returns NULL. The argument is any expression producing text value. It is also applicable to a text list input producing a numeric list result.
ParseReal(source_value)	Parses an input text value and returns a floating-point value. If the conversion is not possible, returns NULL. The argument is any expression producing text value. It is also applicable to a text list input producing a numeric list result.
ParseDate(source_value[, format])	Parses an input text value and returns a date/time value. If the conversion is not possible, returns NULL. The first argument is any expression producing text value. An optional second argument is a string literal defining the expected date format. The following formats are supported: "ymd" - YYYY-MM-DD [hh:mm:ss] "dmy" - DD-MM-YYYY [hh:mm:ss] "mdy" - MM-DD-YYYY [hh:mm:ss] "default" or missing - same are "ymd"# It is also possible to use "/" or "." as date part delimiters.