NUMTOYMINTERVAL

Purpose

This function converts a numerical value n into an interval of type INTERVAL YEAR TO MONTH.

Syntax

numtoyminterval::=

Usage Notes

Example

Copy
SELECT NUMTOYMINTERVAL(3.5,'YEAR') NUMTOYMINTERVAL;