Oracle Time function Numtoyminterval ()

Format: Numtoyminterval (n, Interval_unit); N: Numeric type Interval_unit: ' Year ', ' MONTH ', or other expression that can be converted to one of these two values Numtoyminterval (1, ' Year '): Interval numtoyminterval ( -1, ' month '): One months ago decimal is calculated as an integer, then calculated: Select Sysdate + numtoyminterval (0.1, ' month ') as futur E from dual;\ Future------------------11-oct-13 The result of this function is: "INTERVAL year to MONTH literal". cannot be operated with numeric values. Select 1 + numtoyminterval (1, ' MONTH ') from Dualoracle will return an error. This function is useful when you are doing a date operation. For example: Date after one months: Select Sysdate + numtoyminterval (1, ' MONTH ') from dual;

Oracle Time function Numtoyminterval ()