Table of Contents

Aggregate

  • ARB. The ARB function returns an arbitrary value from a set of values. Generally to pick only one value
RETURN "Customers" AS
SELECT ARB�("CustomerAge") AS "Age" 
GROUP BY "CustomerId"
  • AVG
  • COUNT
  • COUNTDISTINCT
  • MAX
  • MIN
  • MEDIAN
  • STDDEV
  • SUM
  • VARIANCE

Scalar

Function Example
TO_DURATION (time function)
TRUNC Trunc(12345.67 ,-2) = 12300
POWER Power(2,3) = 8
LOG Log(10,1000) = 3
MOD Mod(10,3) = 1
ROUND Round(12.123,2) = 12.12
ABS ABS(-37) = 37
CEIL CEIL(45.37) = 46
COS COS(Pi/3) = .5
EXP EXP(1) = 2.7182818… (e)
FLOOR FLOOR(15.8) = 15
LN LN(2.7182818) = .999999 or LN(e) = 1
SIN SIN(Pi/6) = .5
SQRT SQRT(16) = 4
TAN TAN(Pi/4) = 1
SIGN SIGN(234.23) = 1 or SIGN(-123)=-1

Date/Time

Require a data type of DateTime, Time, Duration

  • DateTime - Integer representing the # of milliseconds since Jan 1, 1970
  • Time –Integer representing the # of milliseconds since midnight
  • Duration – Integer representing the # of elapsed milliseconds