TO_YMINTERVAL

Purpose

This function converts a string value into an interval (INTERVAL YEAR TO MONTH).

Usage Notes

• The string always has format [+|-]YY-MM. Valid values are 0 to 999999999 for years (YY) and 0 to 11 for months (MM).
• For additional information, refer to TO_DSINTERVAL, NUMTODSINTERVAL, and NUMTOYMINTERVAL.

Example