The following are the functions that the Spotfire Data Streams connector supports.
Supported functions are the functions that you can use when you work with in-database data tables, for example for calculated columns and custom expressions.
Important: Some supported functions might not be possible to use with your database. This depends on what functions are available in the database, which often differs between database versions and types
Conversion functions
Boolean, DateTime, Integer, LongInteger, Real, String, TimeSpan
Date and Time functions
DayOfMonth, DayOfWeek, Hour, Minute, Month, Second, Year, date, days, epoch, format_time, from_gmtime, from_localtime, from_unixtime, get_day_of_month, get_day_of_week, get_day_of_year, get_hour, get_millisecond, get_minute, get_month, get_second, get_year, hours, milliseconds, minutes, now, parse_time, seconds, set_day_of_month, set_day_of_week, set_hour, set_minute, set_month, set_second, set_year, strftime, strpinterval, strptime, time, this_month, timezoneoffset, to_milliseconds, to_seconds, today, today_utc, weeks, yesterday
Math functions
abs, acos, asin, atan, atan2, bitand, bitnot, bitor, bitxor, black_scholes, cbrt, ceil, choose, compound_interest, cos, cosh, exp, expm1, factorial, floor, gaussianrandom, isnan, ln, log10, log1p, lshift, notnan, permute, pow, random, round, rshift, sign, sin, sinh, sqrt, tan, tanh, to_degrees, to_radius, unsignedshift
Operations
+, -, *, /, %
Statistical functions
avg, avgif, correlation_coefficient, correlation_coefficientp, count, count_distinct, countif, countlong, covariance, covariancep, firstnonnullval, firstval, intercept, lastnonnullval, lastval, max, min, percentile, product, slope, stdev, stdevp, sum, sumif, variance, variancep, vwap, withmax, withmin
Text functions
contains, endswith, indexof, isempty, lastindexof, lower, ltrim, randomstring, regexmatch, regexmatch_ignorecase, regexplace, replace, rtrim, startswith, strlen, strresizetrunc, substr, upper
Utility functions
coalesce, great_circle_distance, hash, isnull, jsonpath, length, md5, notnull, uuid