Quick Ref.

SQL Functions

Standard SQL functions together with some common non-standard function. MS SQL, Oracle, MySQL and PostgreSQL provide support or have alternatives. Where possible alternatives are given.

ABS CURRENT_TIMESTAMP LENGTH + INTERVAL SUBSTRING (ansi)
AVG DATEPART MAX + (string) SUBSTRING
|| (strings) DAY MIN POSITION SUM
CASE DIV MINUTE QUARTER TAN
CAST EXTRACT MOD RANK TO_CHAR (dates)
CEIL FLOOR MONTH REPLACE TRIM
COALESCE HOUR NULLIF RIGHT YEAR
CONCAT IFNULL NVL ROUND
COS INSTR PATINDEX SECOND
COUNT LEFT % (modulo) SIN
CURRENT_DATE LEN + (dates) SUBSTR