SELECT
TO_CHAR( 1565677503399 / ( 1000 * 60 * 60 * 24 ) + TO_DATE( '1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS' ), 'YYYYMMDDHH24MISS' )
FROM
dual
SELECT
TO_CHAR( 1565677503399 / ( 1000 * 60 * 60 * 24 ) + TO_DATE( '1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS' ), 'YYYYMMDDHH24MISS' )
FROM
dual
本文标题:oracle 毫秒转时间转字符
本文链接:https://www.haomeiwen.com/subject/eeugjctx.html
网友评论