Skip to content

Latest commit

 

History

History
35 lines (29 loc) · 735 Bytes

math-functions.md

File metadata and controls

35 lines (29 loc) · 735 Bytes

Math Functions

[NOTE] The documetation has been updated to reflect that the product name for N1QL has been changed to SQL++, however, the source itself may still use the name N1QL.

Most math functions from the .Net Math class are supported by SQL++. They may be used anywhere in the query, including where predicates, select projections, and sort ordering.

Supported Math Functions

  • Math.Abs
  • Math.Acos
  • Math.Atan
  • Math.Atan2
  • Math.Asin
  • Math.Ceiling
  • Math.Cos
  • Math.Exp
  • Math.Floor
  • Math.Log
  • Math.Log10
  • Math.Pow
  • Math.Round
  • Math.Sign
  • Math.Sin
  • Math.Sqrt
  • Math.Tan
  • Math.Trunc

Supported Math Operators

  • Addition (+)
  • Subtraction/Negation (-)
  • Multiplication (*)
  • Division (/)
  • Modulus (%)