从当前时间中提取出年、月、日、小时、分钟及秒,这里使用到了to_number和to_char两个函数。
SELECT TO_NUMBER (TO_CHAR (SYSDATE, 'hh24')) hour,
TO_NUMBER (TO_CHAR (SYSDATE, 'mi')) MIN,
TO_NUMBER (TO_CHAR (SYSDATE, 'ss')) sec,
TO_NUMBER (TO_CHAR (SYSDATE, 'dd')) day,
TO_NUMBER (TO_CHAR (SYSDATE, 'mm')) mth,
TO_NUMBER (TO_CHAR (SYSDATE, 'yyyy')) year
FROM DUAL;