TO_YMINTERVAL

TO_YMINTERVAL converts a text expression to an INTERVAL YEAR TO MONTH data type.

Return Value

INTERVAL YEAR TO MONTH

Syntax

TO_YMINTERVAL(char)

Arguments

char is any text expression.

Example

TO_YMINTERVAL('01-06') returns the value +1-06.

Copyright © 2003, 2007, Oracle. All rights reserved.