select cast(date as char) as date from table1; 结果如下: date 2015-11-03 15:31:26 select cast(date as datetime) as date from table1; 结果如下: date 2015-11-03 15:31:26 select cast(date as date) as date from table1; 结果如下: date 2015-11-03 select cast(date as time) as...
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-Built-inTable-GeneratingFunctions(UDTF) 常用内置函数 类型转换函数 select cast("5" as int)from dual; select cast("2017-08-03" as date) ; select cast(current_timestamp as date); 示例: create table t_fun(i...
select cast(date as signed) as date from table1; -- 结果如下: date 20151103153126 select cast(date as char) as date from table1; -- 结果如下: date 2015-11-03 15:31:26 select cast(date as datetime) as date from table1; -- 结果如下: date 2015-11-03 15:31:26 select cast(date...
select cast(date as signed) as date from table1; -- 结果如下: date 20151103153126 select cast(date as char) as date from table1; -- 结果如下: date 2015-11-03 15:31:26 select cast(date as datetime) as date from table1; -- 结果如下: date 2015-11-03 15:31:26 select cast(date...