一、实现13位时间戳转毫秒时间类型
select
concat(t,".",substring(1611231717343,11,13))
from(
select from_unixtime(cast(substring(1611231717343,0,10) as bigint),'yyyy-MM-dd HH:dd:ss') as t)tmp;
一、实现13位时间戳转毫秒时间类型
select
concat(t,".",substring(1611231717343,11,13))
from(
select from_unixtime(cast(substring(1611231717343,0,10) as bigint),'yyyy-MM-dd HH:dd:ss') as t)tmp;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
