Basic Oracle Concepts and Programming Question:

You can convert dates to characters using the TO_CHAR() function as shown in the following examples:

SELECT TO_CHAR(TO_DATE('04:49:49', 'HH:MI:SS'),
'DD-MON-YYYY HH24:MI:SS') FROM DUAL;
-- Default date is the first day of the current month
01-MAY-2006 04:49:49

SELECT TO_CHAR(TO_TIMESTAMP('16:52:57.847000000',
'HH24:MI:SS.FF9'), 'DD-MON-YYYY HH24:MI:SS.FF9')
FROM DUAL;
01-MAY-2006 16:52:57.847000000

SELECT TO_CHAR(TO_DATE('69520', 'SSSSS'),
'DD-MON-YYYY HH24:MI:SS') FROM DUAL;
01-MAY-2006 19:18:40