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;
hive cst 时间转换
最新推荐文章于 2024-05-26 17:05:19 发布
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;