Conversion Functions

When necessary, values can be explicitly cast to a particular type.

cast(value AS type) → type

Explicitly cast a value as a type. This can be used to cast a varchar to a numeric value type and vice versa.

try_cast(value AS type) → type

Like cast(), but returns null if the cast fails.

The function supports the following units:

parse_presto_data_size(string)

Parses of format value unit into a number, where value is the fractional number of unit values:

Returns the name of the type of the provided expression: