apply interval day to second function to character data

[mahajanakhil198]

Did you try this in your control file?:

LOAD DATA 
... etc ...
my_interval "TO_DSINTERVAL(:my_interval)",
... etc ...

Is there a way in which to_dsinterval handles the following situation:

SQL> select to_dsinterval(concat('0 ','44:34:54')) from dual;
select to_dsinterval(concat('0 ','44:34:54')) from dual
*
ERROR at line 1:
ORA-01850: hour must be between 0 and 23

Obviously, I won't do that in a sql statement. Actually, the data from csv file comes like this: 44:20:13, 34:14:31. I have avoided converting this data to type interval day to second while loading. So, in oracle table, this data is stored as char type.

After I load data, I need to present this data using select statement as sum of two fields. So, the data in column1(44:20:13) and column2(34:14:31) will be presented in one column as:

select column1+column2 from ;

The output should be +3 06:34:44 or 78:34:44(preferred).