15.3.1 dsintervaltonum(value1, value 2)

DSINTERVALTONUM(c1 INTERVAL DAY TO SECOND, c2 char) - Function will convert interval value(c1) into a numeric value. User must provide unit for the output numeric value as second argument to this function. Allowed values for the unit is: DAY,HOUR,MINUTE,SECOND

Input value 1 can be one of the following types: interval.

Input value 2 can be one of the following types: text.

Returned value will be of type double.

Function Result

dsintervaltonum(calc_7, "MINUTE")

,

301.0

dsintervaltonum(calc_7, "DAY")

5.016666666666667