SELECT TO_CHAR(CURRENT_DATE, 'YYYYMMDD HH24:MI:SS') FROM DUAL; SELECT SYSDATE FROM DUAL; SELECT TO_DATE(to_char(sysdate, 'YYYYMMDD')||' '||'07:29:00', 'YYYYMMDD HH24:MI:SS') FROM DUAL;