NUMTOYMINTERVAL
Converts a number or expression to an INTERVAL YEAR TO MONTH
type.
SQL syntax
NUMTOYMINTERVAL (Expression1, 'IntervalUnit')
Parameters
NUMTOYMINTERVAL
has the parameters:
Parameter | Description |
---|---|
|
The argument can be any |
|
One of the string constants |
Examples
An example using NUMTOYMINTERVAL
:
Command> SELECT SYSDATE + NUMTOYMINTERVAL(1,'MONTH') FROM dual; < 2007-02-28 09:23:28 > 1 row found.