Returns the type of a given expression.

​
Syntax

TYPEOF(<expression>)

​
Parameters

ParameterDescriptionSupported input types
<expression>The expression to typeof.Any

​
Return Types

A text of the given expression data type.

​
Example

The following example returns the type of PI() function:

SELECT TYPEOF(RANDOM()) AS random_data_type;

Returns: double precision