TYPEOF
Returns the type of a given expression.
Syntax
TYPEOF(<expression>)
Parameters
Parameter | Description | Supported 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