NUMTOYMINTERVAL¶

说明¶

将数值转换成INTERVAL YEAR TO MONTH类型

语法¶

numtoyminterval ::=
    NUMTOYMINTERVAL ( int_expression , text_expression )

参数¶

int_expression

待转的整数值

text_expression

待转换数值的单位，YEAR或MONTH

返回值¶

INTERVAL YEAR TO MONTH类型的结果

示例¶

示例1: 将数值转换成INTERVAL YEAR TO MONTH类型

--  将数值转换成INTERVAL YEAR TO MONTH类型
SELECT NUMTOYMINTERVAL(1320, 'MONTH');
NUMTOYMINTERVAL(INTERVALYTM)      |
----------------------------------
+000000110-00                     |
总数目：1


SELECT NUMTOYMINTERVAL('1320', 'YEAR');
NUMTOYMINTERVAL(INTERVALYTM)      |
----------------------------------
+000001320-00                     |
总数目：1