TO_DSInterval Function in Oracle SQL – PLSQL

The TO_DSInterval function in Oracle SQL / PLSQL is used to convert a string value to Interval Day to Second type.

Syntax for the TO_DSInterval function in Oracle SQL / PLSQL is:

SELECT TO_DSInterval(character_1 [nls_parameter])
FROM table_name;

  • character_1 can be CHAR, VARCHAR2, NCHAR or NVARCHAR2 data type, it is the value that will be converted to Interval Day to Second.
  • nls_paramter is a decimal character and group separator value.

Examples:

SELECT TO_DSINTERVAL('50 10:30:00')
FROM dual;

Would return ‘+50 10:30:00.000000’


Tagged , , , , , , , , , , , . Bookmark the permalink.