By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE your_table (your_column) AS
SELECT '13:24:02' FROM DUAL;
1 rows affected
SELECT TO_CHAR(TO_DATE(your_column, 'HH24:MI:SS'), 'HH12:MI:SS AM') AS formatted_time
FROM your_table
| FORMATTED_TIME |
|---|
| 01:24:02 PM |