Date and Time functions
Year, Month, Day, DayOfMonth, Hour, Minute, Second, Quarter
Conversion functions
SN
Math functions
Abs, Log, Ln, Exp, Sqrt, Sin, Cos, Tan, ASin, ACos, ATan, ATan2, Sinh, Cosh, Tanh, ASinh, ACosh, ATanh, NullIfZero, ZeroIfNull, Power
Operators
+, -, *, /, %, Mod
Statistical functions
Sum, Avg, Min, Max, Count, UniqueCount, StdDev_Samp, StdDev_Pop, Var_Samp, Var_Pop, Skew, Kurtosis, CoVar_Pop, CoVar_Samp, Corr, Regr_AvgX, Regr_AvgY, Regr_Count, Regr_Intercept, Regr_R2, Regr_Slope, Regr_SXX, Regr_SYX, Regr_SYY
Text functions
Character_Length, Lower, Upper, Soundex, Trim
Other supported functionality
Binning
Stored procedures
Macros
Note: Macros are handled the same way as stored procedures in Spotfire. When you connect to Teradata, any macros in the database will be available in the list of database tables in the Views in Connection dialog.
Note: Stored procedures that do not result in a data table output will not be visible in the Views in Connection dialog for some connectors. The schema of the stored procedure must not change from time to time (for example, the use of parameters must not change the schema).