In Oracle/PLSQL, the to_dsinterval function converts a string to an INTERVAL DAY TO SECOND type.
Syntax
The syntax for the to_dsinterval function is:
to_dsinterval( character [ nls_parameter ] )
character is the value to convert to an INTERVAL DAY TO SECOND type. It can be a char, varchar2, nchar, or nvarchar2 value.
nls_parameter is a decimal character and group separator value.
Applies To
For Example
| to_dsinterval('150 08:30:00') | would return '+000000150 08:30:00.000000000' |
| to_dsinterval('80 12:30:00') | would return '+000000080 12:30:00.000000000' |
| to_dsinterval('95 18:30:00') | would return '+000000095 18:30:00.000000000' |