Converts numeric_value into an INTERVAL YEAR(4) TO MONTH value.
Syntax
[TD_SYSFNLIB.] NUMTOYMINTERVAL ( numeric_value, interval_unit )
- TD_SYSFNLIB.
- Name of the database where the function is located.
- numeric_value
-
A numeric argument.
If this syntax element is NULL, NULL is returned.
- interval_unit
-
A character expression.
interval_unit specifies the unit of value for numeric_value. It must be one of the following case-insensitive values:- 'YEAR'
- 'MONTH'
Any value that overflows the INTERVAL YEAR(4) TO MONTH value results in an error.
If this syntax element is NULL, NULL is returned.