Subtraction -

Operator: -

The subtraction operator - is used to subtract several values. The values can be of the following type:

  • number

  • duration

  • datetime

  • concept-set

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

value1 - value2

37 - 7 => 30

'1d' - '12h' => 12 hours

Today() - '2d' => day before yesterday

{ 'concept1', 'concept2', 'concept3'} - { 'concept1', 'concept3' } => { 'concept2' }

'1d' - 12 => expression type mismatch

Last updated

Was this helpful?