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
| Arguments | Description |
|---|---|
<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 |
+------------------+