NUMTODSINTERVAL¶

说明¶

将数值转换成INTERVAL DAY TO SECOND类型

语法¶

numtodsinterval ::=
    NUMTODSINTERVAL ( int_expression , text_expression )

参数¶

int_expression

待转的整数值

text_expression

待转换数值的单位，DAY或HOUR或MINUTE或SECOND

返回值¶

INTERVAL DAY TO SECOND类型的结果

示例¶

示例1: 将数值转换成INTERVAL DAY TO SECOND类型

--  将数值转换成INTERVAL DAY TO SECOND类型
SELECT NUMTODSINTERVAL('3224', 'DAY');
NUMTODSINTERVAL(INTERVALDTS)      |
----------------------------------
+003224 00:00:00                  |
总数目：1


SELECT NUMTODSINTERVAL('3224', 'SECOND');
NUMTODSINTERVAL(INTERVALDTS)      |
----------------------------------
+000000 00:53:44                  |
总数目：1