Functions Reference

Language:Project:Language policy	English

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