oracle long转日期 和日期转long时间戳

SELECT
TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH24:mi:ss') + (TO_NUMBER('1761015597082') / (24 * 60 * 60 * 1000)) AS converted_date
FROM dual;

--date转long示例
select sysdate,(sysdate- to_date('1970-01-01','yyyy-mm-dd'))* 246060*1000 as 整型格式 from dual;

--long转date
select to_date('1970-01-0100:00:00','yyyy-mm-dd hh24:mi:ss') + 1761015597082/1000/24/60/60 from dual;