Date and Time functions
Year, Quarter, Month, Week, Day, DayOfMonth, DayOfYear, DayOfWeek, Hour, Minute, Second, Millisecond, Add_months
Conversion functions
SN, To_char
Math functions
Abs, ACos, ASin, ATan, ATan2, Ceil, Cos, Degrees, Ln, Sin, Tan, Cot, Exp, Floor, Log, Pi, Pow, Radians, Round, Sign, Sqrt, Trunc
Operators
+, -, *, /, %
Statistical functions
Sum, Avg, Max, Min, Median, Count, Stddev, Stddev_pop, Stddev_samp, Variance, Var_pop, Var_samp
Text functions
Ascii, Btrim, Chr, Initcap, Instr, Length, Lower, Lpad, Repeat, Rpad, Strpos, Substr, Translate, Unichr, Unicode, Upper, LTrim, RTrim
Other functions
Le_dst, Dle_dst
Binning
Netezza supports binning.