Snippet Name: TO_YMINTERVAL
Description: Converts a character string (CHAR, VARCHAR2, NCHAR, or NVARCHAR2) datatype to an INTERVAL YEAR TO MONTH type, where char is the character string to be converted.
Also see: » Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» UNISTR
» TRANSLATE
» TO_TIMESTAMP_TZ
» TO_TIMESTAMP
» TO_SINGLE_BYTE
» TO_NUMBER
» TO_NCLOB
» TO_NCHAR
» TO_MULTI_BYTE
» TO_LOB
» TO_DSINTERVAL
» TO_DATE
» TO_CLOB
» TO_CHAR
» TO_BINARY_FLOAT
» TO_BINARY_DOUBLE
» TIMESTAMP_TO_SCN
» SCN_TO_TIMESTAMP
» ROWIDTONCHAR
» ROWIDTOCHAR
» REFTOHEX
» RAWTONHEX
» RAWTOHEX
» NUMTOYMINTERVAL
» NUMTODSINTERVAL
» HEXTORAW
» DECOMPOSE
» CONVERT
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 05th, 2009
|
TO_YMINTERVAL(<char>) RETURN YMINTERVAL
-- calculate for each employee in the a date that is one year
-- and four months after the hire date:
SELECT hire_date, hire_date + TO_YMINTERVAL('01-04') "16 months"
FROM employees;
HIRE_DATE 16 months
--------- ---------
17-JUN-87 17-SEP-88
21-SEP-89 21-JAN-91
13-JAN-93 13-MAY-94
03-JAN-90 03-MAY-91
21-MAY-91 21-SEP-92
|