FUNCTIONS

Language: Project:Language policy	English  • Deutsch  • 日本語

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

SQLZoo is seeking advertisers/sponsors ()

Kaleidoscope - get a kaleidoscope view using your phone/laptop camera