TO_DSINTERVAL

Syntax

to_dsinterval::=

Text description of to_dsinterval

Purpose

TO_DSINTERVAL converts a character string of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to an INTERVAL DAY TO SECOND type.

• char is the character string to be converted.

• The only valid NLS parameter you can specify in this function is NLS_NUMERIC_CHARACTERS. This argument can have the form:

  NLS_NUMERIC_CHARACTERS = "dg" 
  
  

  where d and g represent the decimal character and group separator respectively.

Example

The following example selects from the employees table the employees who had already worked for the company for at least 100 days on January 1, 1985:

SELECT employee_id, last_name FROM employees
   WHERE hire_date - TO_DSINTERVAL('100 10:00:00')
   > DATE '1985-01-01';

EMPLOYEE_ID LAST_NAME
----------- ---------------
        100 King
        101 Kochhar
        102 De Haan