NUMTODSINTERVAL

The NUMTODSINTERVAL function converts a number to an INTERVAL DAY TO SECOND literal.

Syntax

NUMTODSINTERVAL (number, 'unit')

Remarks

•

The number argument can be any number value, or an expression that can be implicitly converted to a number value.

•

The unit argument specifies the unit-type of the number argument.

•

The unit argument must be a CHAR with a value of DAY, HOUR, MINUTE, or SECOND.

•

The unit argument is case-insensitive, and leading and trailing values within the parentheses are ignored.

•

The precision of the return is 9.

Example

NUMTODSINTERVAL (200, ' day ')

NUMTODSINTERVAL (1200, 'Minute ')

NUMTODSINTERVAL (8, 'HOUR')

Top