24小时格式: select to_number(to_char(sysdate, 'yyyymmddHH24MISS')) from dual; 转载于:https://www.cnblogs.com/skiing886/p/7929207.html