Operators Operator

*

Operands & returns

17 overloads

Operator

Overload link	`left`	`right`	Returns
#01	`BIGINT`	`BIGINT`	`BIGINT`
#02	`BIGINT`	`INTERVAL`	`INTERVAL`
#03	`DECIMAL`	`DECIMAL`	`DECIMAL`
#04	`DOUBLE`	`DOUBLE`	`DOUBLE`
#05	`DOUBLE`	`INTERVAL`	`INTERVAL`
#06	`FLOAT`	`FLOAT`	`FLOAT`
#07	`HUGEINT`	`HUGEINT`	`HUGEINT`
#08	`INTEGER`	`INTEGER`	`INTEGER`
#09	`INTERVAL`	`BIGINT`	`INTERVAL`
#10	`INTERVAL`	`DOUBLE`	`INTERVAL`
#11	`SMALLINT`	`SMALLINT`	`SMALLINT`
#12	`TINYINT`	`TINYINT`	`TINYINT`
#13	`UBIGINT`	`UBIGINT`	`UBIGINT`
#14	`UHUGEINT`	`UHUGEINT`	`UHUGEINT`
#15	`UINTEGER`	`UINTEGER`	`UINTEGER`
#16	`USMALLINT`	`USMALLINT`	`USMALLINT`
#17	`UTINYINT`	`UTINYINT`	`UTINYINT`

Used in larger rewrites 1

These examples use * as one part of a larger SQL translation.

SELECT RANDOM()

In DuckDB

SELECT CAST(-9.223372036854776E+18 + RANDOM() * (9.223372036854776e+18 - -9.223372036854776E+18) AS BIGINT)