I have a PROCESS\_TIME with data type VARCHAR2(32), 
in which I store the times as **hh24:mi:ss**,
and I intend to add these times on some grouping logic.

A minified version of the table

```
CREATE TABLE "SCHEMA"."MY_TABLE" 
   (    "MY_TABLE_ID" VARCHAR2(32 BYTE) NOT NULL ENABLE, 
    "START_TIME" DATE NOT NULL ENABLE, 
    "END_TIME" DATE NOT NULL ENABLE, 
    "LOAD_PROCESS_TIME" VARCHAR2(32 BYTE) DEFAULT '00:00:00', 
   ) 

```

and a minified version of Insert

```
Insert into MY_TABLE (MY_TABLE_ID,START_TIME,END_TIME,LOAD_PROCESS_TIME) 
values ('8880508C9AC4441DB8E16E023F206C2F',to_date('05/11/2018 07:22','MM/DD/YYYY HH:MI'),to_date('05/11/2018 08:22','MM/DD/YYYY HH:MI'),'01:00:14');

Insert into MY_TABLE (MY_TABLE_ID,START_TIME,END_TIME,LOAD_PROCESS_TIME) values ('C858EB646A794D04B5C77779C50EBFCF',
to_date('05/12/2018 10:20','MM/DD/YYYY HH:MI'),
to_date('05/12/2018 11:20','MM/DD/YYYY HH:MI'),
'02:30:10');

```

Intended Query

```
SELECT TO_CHAR(TRUNC(END_TIME, 'DD'), 'DD-MON-YY'),
sum(LOAD_PROCESS_TIME)
FROM MY_TABLE 
WHERE END_TIME > SYSDATE -14 
GROUP BY TRUNC(END_TIME,'DD') 
ORDER BY TRUNC(END_TIME,'DD');

```

Can you please help me achieve this using Oracle SQL?