oracle账号无法修改数据oracle对日期的操作讲解

–日期转毫秒值

select to_number(sysdate-to_date('1970-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))*24*60*60*1000 from dual;

–毫秒值转日期

select to_char((1523476222000/1000/60/60/24+to_date('1970-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS')),'YYYY-MM-DD HH24:MI:SS') from dual;

–获取当前日期

select sysdate frooracle账号m dual;