../E23381-01.epub /> ../E23381-01.mobi />

NUMTODSINTERVAL

NUMTODSINTERVAL converts a number to an INTERVAL DAY TO SECOND data type.

Return Value

INTERVAL DAY TO SECOND

Syntax

NUMTODSINTERVAL(n, 'interval_unit')

Arguments

n can be any numeric expression.

interval_unit is a text expression that specifies the units. It must resolve to one of the following values:

  • DAY

  • HOUR

  • MINUTE

  • SECOND

These values are case insensitive.

Example

NUMTODSINTERVAL(100, 'MINUTE') returns the value +00 01:40:00.000000.