hive cst 时间转换

select from_unixtime(unix_timestamp(r.collecttime,'EEE MMM dd HH:mm:ss zzz yyyy'),'yyyy-MM-dd HH:mm:ss')
from  r_contactcheat_detail r  limit 5;

转载于:https://www.cnblogs.com/canyangfeixue/p/6740068.html