sqlways:postgresql:functions:mapping-to-other-databases

PostgreSQL - SQL Functions Mapping to Other Databases

PostgreSQL	Oracle	SQL Server	IBM DB2	MySQL
ABS	ABS	ABS	ABS	ABS
ACOS	ACOS	ACOS	ACOS	ACOS
ASIN	ASIN	ASIN	ASIN	ASIN
ATAN	ATAN	ATAN	ATAN	ATAN
ATAN2	ATAN2	ATN2	ATAN2	ATAN2
CBRT
CEIL	CEIL	CEILING	CEILING	CEILING
COS	COS	COS	COS	COS
COT		COT	COT	COT
DEGREES		DEGREES	DEGREES	DEGREES
DIV				DIV
EXP	EXP	EXP	EXP	EXP
FLOOR	FLOOR	FLOOR	FLOOR	FLOOR
LN	LN	LOG	LN	LN
LOG	LOG	LOG10	LOG10	LOG10
MOD	MOD		MOD	MOD
PI		PI		PI
POWER	POWER	POWER	POWER	POWER
RADIANS		RADIANS	RADIANS	RADIANS
RANDOM		RAND	RAND	RAND
ROUND	ROUND (number)	ROUND	ROUND	ROUND
SIGN	SIGN	SIGN	SIGN	SIGN
SIN	SIN	SIN	SIN	SIN
SQRT	SQRT	SQRT	SQRT	SQRT
TAN	TAN	TAN	TAN	TAN
TRUNC	TRUNC (number)		TRUNCATE	TRUNCATE

PostgreSQL	Oracle	SQL Server	IBM DB2	MySQL
ASCII	ASCII	ASCII	ASCII	ASCII
BIT_LENGTH				BIT_COUNT
BTRIM	TRIM		STRIP	TRIM
CHR	CHR	CHAR	CHR	CHAR
GET_BIT
GET_BYTE
INITCAP	INITCAP
LENGTH	LENGTH	LEN	LENGTH	CHAR_LENGTH
CHAR_LENGTH	LENGTH	LEN	LENGTH	CHAR_LENGTH
LOWER	LOWER	LOWER	LCASE	LOWER
LPAD	LPAD			LPAD
LTRIM	LTRIM	LTRIM	LTRIM	LTRIM
OCTET_LENGTH	LENGTH	LEN	LENGTH	CHAR_LENGTH
OVERLAY		STUFF	INSERT	INSERT
POSITION	INSTR	CHARINDEX	LOCATE	INSTR
QUOTE_IDENT		QUOTENAME
QUOTE_LITERAL				QUOTE
REGEXP_MATCHES	REGEXP_SUBSTR
REGEXP_REPLACE	REGEXP_REPLACE
REGEXP_SPLIT_TO_TABLE
REGEXP_SPLIT_TO_TO_ARRAY
REPEAT		REPLICATE	REPEAT	REPEAT
REPLACE	REPLACE	REPLACE	REPLACE	REPLACE
RPAD	RPAD			RPAD
RTRIM	RTRIM	RTRIM	RTRIM	RTRIM
SET_BIT
SET_BYTE
SPLIT_PART
STRPOS	INSTR	CHARINDEX	LOCATE	INSTR
SUBSTR	SUBSTR	SUBSTRING	SUBSTR	SUBSTR
TRANSLATE	TRANSLATE		TRANSLATE
TRIM	TRIM		STRIP	TRIM
UPPER	UPPER	UPPER	UCASE	UPPER