Date and Time functions
Year, Quarter, Month, Week, DayOfMonth, DayOfYear, DayOfWeek, Hour, Minute, Second, CurDate, CurTime, DayName, FormatDate, FormatTime, FormatTimestamp, ModifyTimeZone, MonthName, ParseDate, ParseTime, ParseTimestamp, TimestampCreate
Math functions
Degrees, Abs, Mod, Pi, Radians, Rand, ACos, ASin, Cos, Cot, Sin, Tan, Ceiling, Exp, Floor, Log10, Log, Power, Round, Sign, Sqrt, ATan, ATan2
Operators
+, -, *, /
Statistical functions
Sum, Avg, Min, Max, Count, UniqueCount, Stddev_pop, Stddev_samp, Var_pop, Var_samp
Text functions
Concat, Concat2, Initcap, Length, Lcase, Lpad, Ltrim, Rtrim, Rpad, Repeat, Replace, Trim, Ucase, Ascii, Chr, Left, Right, Substring, Translate, Convert, EndsWith, Insert, Locate, Space, Unescape
Binning is not supported by this connector.
AI-SQL functions
Note: The AI-SQL functions are not supported as functions in calculated columns, custom expressions or other Spotfire interfaces. However, they can be used in custom queries.
ADVANCEDSEARCH, ENDSWITH, ENTITY, EQUALS, FULLTEXTSEARCH, FUZZY, NEAR, ONEAR, REGEX,SIMPLESEARCH, STARTSWITH, TERM, AIESCORE