oracle日期转整数

24小时格式:

select to_number(to_char(sysdate, 'yyyymmddHH24MISS')) from dual;

原文地址:https://www.cnblogs.com/skiing886/p/7929207.html