Date and Time functions
YEAR, QUARTER, MONTH, WEEK, WEEKOFYEAR, WEEKOFMONTH, DAY, DAYOFWEEK, DAYOFMONTH, DAYOFYEAR, HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND
Conversion functions
SN
Math functions
ABS, ACOS, ASIN, ATAN, CBRT, CEILING, COS, COT, DEGREES, EXP, FLOOR, LN, LOG, MOD, PI, POWER, RADIANS, RANDOM, ROUND, SIGN, SIN, SQRT, TAN, TRUNC
Operators
%, -, +, *, /
Statistical functions
SUM, AVG, MIN, MAX, COUNT, UNIQUECOUNT, VARIANCE, VAR_POP, VAR_SAMP, STDDEV, STDDEV_POP, STDDEV_SAMP
Text functions
CONCAT, INITCAP, LENGTH, LOWER, LPAD, LTRIM, MD5, RPAD, REPEAT, REPLACE, RTRIM, STRPOS, SUBSTR, TRIM, UPPER
Binning is supported by this connector.
See also:
Details on Pivotal Greenplum Connection