to_yminterval
来源:互联网 发布:m2m 物联网 java 技术 编辑:程序博客网 时间:2024/06/05 18:42
Syntax
to_yminterval::=
Description of the illustration to_yminterval.gif
Purpose
TO_YMINTERVAL converts a character string of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to an INTERVAL YEAR TO MONTH type, where char is the character string to be converted.
Examples
The following example calculates for each employee in the sample hr.employees table a date one year two months after the hire date:
SELECT hire_date, hire_date + TO_YMINTERVAL('01-02') "14 months"
FROM employees;
HIRE_DATE 14 months
--------- ---------
17-JUN-87 17-AUG-88
21-SEP-89 21-NOV-90
13-JAN-93 13-MAR-94
03-JAN-90 03-MAR-91
21-MAY-91 21-JUL-92
. . .
to_yminterval::=
Description of the illustration to_yminterval.gif
Purpose
TO_YMINTERVAL converts a character string of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to an INTERVAL YEAR TO MONTH type, where char is the character string to be converted.
Examples
The following example calculates for each employee in the sample hr.employees table a date one year two months after the hire date:
SELECT hire_date, hire_date + TO_YMINTERVAL('01-02') "14 months"
FROM employees;
HIRE_DATE 14 months
--------- ---------
17-JUN-87 17-AUG-88
21-SEP-89 21-NOV-90
13-JAN-93 13-MAR-94
03-JAN-90 03-MAR-91
21-MAY-91 21-JUL-92
. . .
- to_yminterval
- Oracle TO_YMINTERVAL 函数简介
- JAVA可重入锁ReentrantLock和synchronized关键字
- 多元huffman码变形
- MFC实现画图工具中的画线功能(一)
- 面试体验:Facebook 篇
- RAC维护工具集
- to_yminterval
- 解决wordpress3.5安装插件和主题失败的问题
- r12.2——adop简介
- Ubuntu 配置 samba 实现文件夹共享
- Linux信号集 —— Signal set and using
- jdk-6u45-linux-x64.bin
- requires 'org.eclipse.wst.sse.core 0.0.0' but it could not be found
- 为什么C++编译器不能支持对模板的分离式编译--error LNK2019: 无法解析的外部符号
- .NET——内存分配