【Hive】毫秒时间戳格式化
1. 除以1000,再格式化
select from_unixtime(cast(server_time/1000 as bigint), 'yyyy-MM-dd') date
from access_log;
2. 字符串切割掉后3位,再格式化
select from_unixtime(cast(substring(server_time, 1, 10) as bigint),'yy...
原创
2019-07-05 11:26:02 ·
3202 阅读 ·
0 评论