oracle 毫秒转时间转字符
2019-08-14 本文已影响0人
KricYi
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