Supported Functions


Date and time functions

Millennium, Year, Quarter, Month, Week, Day, DayOfMonth, DayOfYear, DayOfWeek, Hour, Minute, Second, Millisecond

Conversion functions

SN

Math functions

Abs, ACos, ASin, ATan, ATan2, Cbrt, Ceiling, Checksum, Cos, Cot, Degrees, DExp, DLog1, DLog10, Exp, Floor, Ln, Log, Mod, Pi, Power, Radians, Random, Round, Sin, Sign, Sqrt, Tan, Trunc

Operators

+, -, *, /, %

Statistical functions

Sum, Avg, Min, Max, First, Last, Count, UniqueCount, Stddev_Pop, Stddev_Samp, Var_Pop, Var_Samp

Text functions

Concat, Initcap, LeftStr, Length, Lower, LTrim, Md5, RightStr, RTrim, Repeat, Replace, Reverse, Strpos, Trim, Upper, Char_Length, BTrim, Chr, To_Hex, Translate

Binning

Binning is not supported.

See also:

Details on Amazon Redshift Connection

Amazon Redshift Data Types