TO_DSINTERVAL

Description of to_dsinterval.eps follows

TO_DSINTERVAL converts its argument to a value of INTERVAL DAY TO SECOND data type.

TO_DSINTERVAL accepts argument in one of the two formats:

  • SQL interval format compatible with the SQL standard (ISO/IEC 9075)
  • ISO duration format compatible with the ISO 8601:2004 standard

EXAMPLE 1

The following example uses the SQL format to select from the hr.employees table the employees who had worked for the company for at least 100 days on November 1, 2002:

EXAMPLE 2

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/TO_DSINTERVAL.html#GUID-DEBB41BD-9438-4558-A53E-428CE93C05D3

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top