Links
Comment on page

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' }