Multiplication

Multiplication operator.

Returns the product of two numeric operands.

Category: binary

SQL symbol: *

Example

SELECT 1.5 * 1.5; -- expected: 2.25

Signatures

• decimal * decimal → decimal
• decimal * integer → decimal
• double * double → double
• double * integer → double
• integer * decimal → double
• integer * double → double
• integer * integer → integer

Types

• Left: decimal, double, integer
• Right: decimal, double, integer
• Result: decimal, double, integer