Dremio Cloud
Dremio Software
 
On this page

    Categories: Datatype

    TYPEOF

    Reports the type (in string format) of the input expression.

    Syntax

    TYPEOF(input any) → varchar

    • input: An expression for which the type is returned.

    Examples

    TYPEOF example 
    SELECT TYPEOF(TRUE)
-- BIT
    TYPEOF example 
    SELECT TYPEOF(100)
-- INT
    TYPEOF example 
    SELECT TYPEOF(98.76)
-- DECIMAL
    TYPEOF example 
    SELECT TYPEOF('2021-09-14')
-- VARCHAR