Home > Teradata Aster > Supported Functions
Date and Time functions
Millennium, Century, Decade, Year, Quarter, Month, Week, DayOfWeek, DayOfYear, DayOfMonth, Day, Hour, Minute, Second, MilliSeconds, MicroSeconds, Date_Trunc
Conversion functions
SN
Math functions
Abs, Cbrt, Ceil, Degress, Exp, Floor, Ln, Log, Mod, Pi, Power, Radians, Round, Sign, Sqrt, Trunc, ACos, ASin, ATan, ATan2, Cos, Cot, Sin, Tan
Operators
+, -, *, /, %
Statistical functions
Sum, Avg, Min, Max, Count, UniqueCount, Stddev, Stddev_Pop, Stddev_Samp, Variance, Var_Pop, Var_Samp
Text functions
Bit_Length, Char_Length, Lower, Octet_Length, Ascii, Btrim, InitCap, Length, Lpad, Ltrim, Md5, Regexp_Replace, Repeat, Replace, Rpad, Rtrim, Split_part, Strpos, Substr, Translate
Binning is not supported by this connector.
See also: