TO_YMINTERVAL

Purpose

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

Syntax

to_yminterval::=

To YMINTERVAL

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

Copy

SELECT TO_YMINTERVAL('3-11') TO_YMINTERVAL;