Supported Functions


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

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).

See also:

Details on Teradata Connection

Teradata Data Types