TYPEOF

Returns the type of a given expression.

Syntax

TYPEOF(<expression>)

Parameter	Description	Supported input types
`<expression>`	The expression to typeof.	Any

A text of the given expression data type.

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

SELECT TYPEOF(RANDOM()) AS random_data_type;

random_data_type text
double precision

Rows: 1Execution time: 4.45ms

⌘I