1、语法
expr1 * expr2
2、说明
返回expr1乘以expr2的运算结果。
乘法运算的类型与结果如下图所示。
详细内容参考类型间转换（type conversion）。
表 1 数字型 * 运算
expr1 (expr2) | expr2 (expr1) | 结果类型 |
NATIVE INTEGER系列 ● NATIVE_SMALLINT ● NATIVE_INTEGER ● NATIVE_BIGINT | NATIVE INTEGER系列 ● NATIVE_SMALLINT ● NATIVE_INTEGER ● NATIVE_BIGINT |
NATIVE_BIGINT |
NUMBER | NUMBER | NUMBER |
NATIVE DOUBLE系列 ● NATIVE_REAL ● NATIVE_DOUBLE | NATIVE DOUBLE系列 ● NATIVE_REAL ● NATIVE_DOUBLE |
NATIVE_DOUBLE |
表 2 INTERVAL * 运算
expr1 (expr2) | expr2 (expr1) | 结果类型 |
INTERVAL YEAR TO MONTH | 数字型类型 | INTERVAL YEAR TO MONTH （结果类型为interval type。） |
INTERVAL DAY TO SECOND | 数字型类型 | INTERVAL DAY TO SECOND （结果类型为interval type。） |
表 3 表中的INTERVAL类型包含的INTERVAL详细类型
INTERVAL YEAR TO MONTH | INTERVAL DAY TO SECOND |
● INTERVAL DAY | |
● INTERVAL HOUR | |
● INTERVAL MINUTE |
INTERVAL YEAR TO MONTH | INTERVAL DAY TO SECOND |
● INTERVAL YEAR ● INTERVAL MONTH ● INTERVAL YEAR TO MONTH | ● INTERVAL SECOND ● INTERVAL DAY TO HOUR ● INTERVAL DAY TO MINUTE ● INTERVAL DAY TO SECOND ● INTERVAL HOUR TO MINUTE ● INTERVAL HOUR TO SECOND ● INTERVAL MINUTE TO SECOND |
3、示例
gSQL> SELECT INTERVAL'1-2'YEAR TO MONTH * 2 AS RESULT FROM DUAL;
RESULT
----------
+000002-04
1 row selected.
gSQL> SELECT INTERVAL'1 01:02:03.400000'DAY TO SECOND * 2 AS RESULT
FROM DUAL;
RESULT
-----------------------
+000002 02:04:06.800000
1 row selected.