Description: NUMTOYMINTERVAL converts number n to an INTERVAL YEAR TO MONTH literal. The argument n can be any NUMBER value or an expression that can be implicitly converted to a NUMBER value. The argument interval_unit can be of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype. The value for interval_unit specifies the unit of n and must resolve to one of the following string values:
'interval_unit' is case insensitive. Leading and trailing values within the parentheses are ignored. By default, the precision of the return is 9.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
NUMTOYMINTERVAL(n,<interval_unit>)-- The following example uses NUMTOYMINTERVAL in a SUM -- analytic function to calculate, for each employee, the -- total salary of employees hired in the past one year -- from his or her hire date.
SELECT last_name, hire_date, salary,SUM(salary)
OVER (ORDERBY hire_date
RANGENUMTOYMINTERVAL(1,'year') PRECEDING)AS t_sal
LAST_NAME HIRE_DATE SALARY T_SAL
------------------------- --------- ---------- ----------
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.