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