Quick Ref.
Functions
date
number
string
Data Types
date
number
string

SQL Functions

Each page includes a compatability table showing which of SQL Server, Oracle, MySQL and PostgreSQL provide support. 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