1.SQL函数
1.1 类型检测函数
toTypeName
select toTypeName(0); -- UInt8
select toTypeName(-0); -- UInt8
select toTypeName(1000); -- UInt16
select toTypeName(-1000); -- Int16
select toTypeName(10000000); -- UInt32
select toTypeName(-10000000); -- Int32
select toTypeName(1.99); -- Float64
select toTypeName(toFloat32(1.99)); -- Float32
select toTypeName(toDate('2019-12-12')) as dateType, toTypeName(toDateTime('2019-12-12 12:12:12')) as dateTimeType; -- Date | DateTime
select toTypeName([1,3,5]); -- Array(UInt8)