Oracle/PLSQL: To_DSInterval Function

In Oracle/PLSQL, the to_dsinterval function converts a string to an INTERVAL DAY TO SECOND type.

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:

• Oracle 9i, Oracle 10g, Oracle 11g

For example:

to_dsinterval('150 08:30:00')	would return '+000000150'
to_dsinterval('80 12:30:00')	would return '+000000080'
to_dsinterval('95 18:30:00')	would return '+000000095'