func

CREATE OR REPLACE FUNCTION format_ts(p_ts TIMESTAMP) RETURN VARCHAR2 IS
BEGIN
RETURN TO_CHAR(p_ts, 'Mon FMDD YYYY') || ' ' ||
TO_CHAR(p_ts, 'FMHH12') || ':' ||
TO_CHAR(p_ts, 'MI') || ':' ||
TO_CHAR(p_ts, 'SS') || ':' ||
TO_CHAR(p_ts, 'FF3') ||
TO_CHAR(p_ts, 'AM');
END;
/

-- Example usage
SELECT format_ts(INTERNTIMESTAMP) AS formatted_ts
FROM CACHECPLSORDER
WHERE ROWNUM = 1;

-- Drop the function when done
DROP FUNCTION format_ts;