Need On-premises/Cloud docs? ->

Native cloud deployment on Azure is currently not available for Exasol 8, but you can install Exasol as a Linux application on Azure VM instances. For more information, see Installation.

Native cloud deployment on GCP is currently not available for Exasol 8, but you can install Exasol as a Linux application on GCP VM instances.

NUMTODSINTERVAL

Purpose

This function converts a numerical value n into an interval of type INTERVAL DAY TO SECOND.

Syntax

numtodsinterval::=

Numtodisinterval

Usage Notes

The parameter interval_unit can be either DAY, HOUR, MINUTE or SECOND.
For additional information, see NUMTOYMINTERVAL, TO_DSINTERVAL, and TO_YMINTERVAL.

Example

SELECT NUMTODSINTERVAL(3.2,'HOUR') NUMTODSINTERVAL;

NUMTODSINTERVAL

Purpose

Syntax

Usage Notes

Example

PRODUCT

RESOURCES