Addition +

Operator: +

The Addition operator + is used to add several values.

The values can be of the following type:

• text

• number

• duration

• datetime

• concept

• concept_set

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

Returns a new value that is the result of adding value1 and value2.

The type of the resulting value is dependent on the types of value1 and value2:

• text + text returns a text

• number + number returns a number

• duration + duration returns a duration

• datetime + duration returns a datetime

• concept + concept returns a concept_set

• concept + concept_set returns a concept_set

• concept_set + concept_set returns a concept_set

value1 + value2

"Hello" + ", " + "world" => "Hello, world"

15 + 8 + 7 => 30

'1d' + '6h' + '30m' => 1 day, 6 hours and 30 minutes

Today() + '1d' => tomorrow

'concept1' + 'concept2' => { 'concept1', 'concept2' }