Multiplication *

Operator: *

The multiplication operator * is used to multiply several values. The values can be of the following type:

• number

• duration

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new value that is the result of multiplying value1 and value2. The type of the value depends on the types of value1 and value2:

• number * number returns a number

• number * duration returns a duration

• duration * number returns a duration

value1 * value2

37 * 7 => 259

24 * '1h' => 1 day

'2m' * 30 => 1 hour

'1d' * '2h' => expression type mismatch