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;

执行结果如下：

如果想转换成"yyyy-MM-dd HH:dd:ss"，需要将13位时间戳转换成11位时间戳，注意转换过程中函数入参数据类型

lenTxt = len(txt) lenTxt_utf8 = len(txt.encode('utf-8')) size = int((lenTxt_utf8 - lenTxt)/2 + lenTxt) print("size = " , size ," ,urf8 = ",lenTxt_utf8," ,len = " ,lenT