to_<type>

to_char(value) ¶

to_uchar(value) ¶

to_short(value) ¶

to_ushort(value) ¶

to_int(value) ¶

to_uint(value) ¶

to_long(value) ¶

to_ulong(value) ¶

return value of any (reasonable) data type converted to given integral data type.

to_float(value) ¶

to_double(value) ¶

return value of any (reasonable) data type converted to float or double,

to_decimal(value,n) ¶

return value of any (reasonable) data type converted to decimal with scale ‘n’ (i.e. decimal places).

to_date(value) ¶

to_time(value) ¶

to_time_ns(value) ¶

to_interval(value) ¶

to_interval_ns(value) ¶

to_datetime(value) ¶

to_timestamp(value) ¶

return value of any (reasonable) data type converted to given date/time data type.

str_to_ipv4(str) ¶

str_to_ipv6(str) ¶

(since EVL 2.4)
convert string ‘str’ to IPv4 or IPv6.