Expression arithmetic operators

During each stage of the pipeline, we can apply one or more arithmetic operators to perform intermediate calculations.

  • $abs, the absolute value.
  • $add, can add numbers or a number to a date to get a new date.
  • $ceil / $floor, ceiling and floor functions.
  • $divide, to divide between two inputs.
  • $exp, raises the natural number e to the specified exponential power.
  • $pow, raises a number to the specified exponential power.
  • $ln / $log / $log10. To calculate the natural log, the log on a custom base or a log base 10 respectively.
  • $mod, the modular value.
  • $multiply, to multiply between inputs.
  • $sqrt, the square root of the input.
  • $subtract, the result of subtracting the second value from the first. If both arguments are dates, returns the difference between them. If one argument is a date (has to be the first argument) and the other is a number, returns the resulting date.
  • $trunc, to truncate the result.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.188.96.5