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
Binning
Binning is supported.
See also:
Details on Teradata Connection