TYPEOF

TYPEOF function is used to return the name of a data type.

Analyze Syntax

func.typeof( <expr> )

Analyze Examples

func.typeof(1)
┌──────────────────┐
 func.typeof(1)   
├──────────────────┤
 INT              
└──────────────────┘

SQL Syntax

TYPEOF( <expr> )

Arguments

ArgumentsDescription
<expr>Any expression.
This may be a column name, the result of another function, or a math operation.

Return Type

String

SQL Examples

SELECT typeof(1::INT);
┌──────────────────┐
 typeof(1::Int32) 
├──────────────────┤
 INT              
└──────────────────┘