SELECT 1197902428593 / 1000 / 60 / 60 / 24 +
TO_DATE('1970-01-01 08:00:00', 'yyyy-MM-dd hh:mi:ss')
FROM DUAL;
毫秒数转换日期
TO_DATE('1970-01-01 08:00:00', 'yyyy-MM-dd hh:mi:ss')
FROM DUAL;
毫秒数转换日期
反过来
select
(to_date('2006-1-1 12:30:25','yyyy-mm-dd hh:mi:ss')-to_date('1970-1-1','yyyy-mm-dd'))
*24*60*60*1000 resulttime
from dual;
(to_date('2006-1-1 12:30:25','yyyy-mm-dd hh:mi:ss')-to_date('1970-1-1','yyyy-mm-dd'))
*24*60*60*1000 resulttime
from dual;