Functions Reference

Functions

Concatenate strings

Extracting substrings

lower case

Finding Substring

Formatting numbers

Replace NULL

Conditional values

Time now

Format dates

SQL Functions

Standard SQL functions and 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