If the source character string contains values not normalized in the INTERVAL form, but which nevertheless can be converted to a proper INTERVAL, the conversion is made.
For example, the following query returns '-267-06'
SELECT CAST('265-30' AS INTERVAL YEAR(4) TO MONTH);