Date and Time functions
Year, Quarter, Month, Week, Day, DayOfMonth, DayOfYear, DayOfWeek, Hour, Minute, Second, Millisecond
Conversion functions
SN
Math functions
Abs, ACos, ASin, ATan, ATan2, Cos, Sin, Tan, Cot, Exp, Floor, Log, Pow, Sqrt
Operators
+, -, *, /, %
Statistical functions
Sum, Avg, Max, Min, Count, Stddev, Stddev_pop, Stddev_samp, Variance, Var_pop, Var_samp
Text functions
Length, Lower, Upper, LTrim, RTrim
Binning
Netezza supports binning.