# Multiplication \*

{% hint style="info" %}
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](https://docs.wem.io/platform/wemreference/sql-compatibility).
{% endhint %}

{% hint style="success" %}
Returns a new <mark style="color:green;">value</mark> 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
  {% endhint %}

<details>

<summary><mark style="color:blue;"><code>value1</code></mark><code> * </code><mark style="color:blue;"><code>value2</code></mark></summary>

`37 * 7`\
\&#xNAN;*=> 259*

`24 * '1h'`\
*=> 1 day*

`'2m' * 30`\
*=> 1 hour*

`'1d' * '2h'`\
\&#xNAN;*=> <mark style="color:red;">expression type mismatch</mark>*

</details>