Opteryx Documentation/Docs

Multiplication

Returns the product of two numeric operands.

Category: binary

SQL symbol: *

Syntax

sql

<left> * <right>

Parameters

<left> — A numeric value. Accepts decimal, float, integer.
<right> — A numeric value. The result takes the wider of the two types - see Signatures. Accepts decimal, float, integer.

Returns

decimal, float, integer

Examples

sql

SELECT name, diameter * 2 FROM $planets LIMIT 3;

Mercury | 9758
Venus | 24208
Earth | 25512

Signatures

decimal * decimal → decimal
decimal * float → float
decimal * integer → decimal
float * decimal → float
float * float → float
float * integer → float
integer * decimal → decimal
integer * float → float
integer * integer → integer

See Also