Description of to_yminterval.eps follows

TO_YMINTERVAL converts its argument to a value of INTERVAL MONTH TO YEAR data type.

For the argument, you can specify any expression that evaluates to a character string of CHARVARCHAR2NCHAR, or NVARCHAR2 data type.


The following example calculates for each employee in the sample hr.employees table a date one year two months after the hire date:

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top