Convert string to an interval Day to Second type in oracle using TO_DSINTERVAL function

This explains how to convert the string to an interval Day to Second type in oracle.

There is a conversion function in oracle by the name, TO_DSINTERVAL which converts the specified string to an interval Day to Second type in oracle.

Syntax: TO_DSINTERVAL(char, [nls])

Here char is the value of the string that needs to be converted and it can be a char, varchar2, nchar or nvarchar2 type. nls is the decimal and group separator characters which are optional. In order to specify this you need to use this as NLS_NUMERIC_CHARACTERS = “dg” where d is the decimal character and g is the group seperator character.

Ex1: SELECT TO_DSINTERVAL('1012 12:12:12') FROM dual;
This returns “+1012 12:12:12.000000” as result

Ex2: SELECT TO_DSINTERVAL('103 10:12:12') FROM dual;
This returns “+103 10:12:12.000000” as result

Ex3: SELECT TO_DSINTERVAL('1012 12:12:12','NLS_NUMERIC_CHARACTERS = ".,"') FROM dual;
This returns “+1012 12:12:12.000000” as result