Term: TO_DSINTERVAL

Definition:
The TO_DSINTERVAL function converts a character string of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to an INTERVAL DAY TO SECOND value.

char is the character string to be converted.

The only valid nlsparam you can specify in this function is NLS_NUMERIC_CHARACTERS. This argument takes the form:

NLS_NUMERIC_CHARACTERS = "dg"

Where d and g represent the decimal character and group separator respectively. Neither character can be a space.

Related Links:

Oracle Conversion Functions: TO_DSINTERVAL
Oracle PL/SQL Snippet: TO_DSINTERVAL

Related Code Snippets:

Date Functions: TO_DSINTERVAL - Converts a string to an INTERVAL DAY TO SECOND DataType.
TO_DSINTERVAL - Converts a character string of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to an ...