MSQL Reference



The following is a reference of all the built-in MSQL functions, divided into six categories (with spatial functions further divided into subcategories).

MSQL Built-in Functions:

Generic	Aggregate	Mathematical	String	Range	Temporal	Table
ABS	ANY_VALUE	ACOS	BASE64_DECODE	DURATION	CURRENT_TS	CONST.SEQUENCE
CAST	AVG	ACOSH	BASE64_ENCODE	LBOUND	CURRENT_TZ	MAP.GEOCODE_AREAS
COALESCE	BIT_AND	ASIN	BTRIM	LERP	DAY	MAP.GEOCODE_LINES
GREATEST	BIT_OR	ASINH	CHAR_LENGTH	MIDPOINT	DAYS	MAP.GEOCODE_PTS
IF	BIT_XOR	ATAN	CHR	RANGE	DOW	MAP.REV_GEOCODE
IFNOTNULL	BOOL_AND	ATAN2	CONCAT	RBOUND	DOY	MAP.ROUTE
LEAST	BOOL_OR	ATANH	CONCAT_WS	RDISTANCE	HOUR
MAXIMUM	CORR	CBRT	ENDS_WITH	REXPAND	HOURS
MINIMUM	COUNT	CEIL	FORMAT	RNORMALIZE	ISODOW
NULLIF	COVAR_POP	COS	HEX_DECODE	RSPAN	ISOWEEK
SIGN	COVAR_SAMP	COSH	HEX_ENCODE	RVALID	MILLISECOND
	MAX	DEGREES	INITCAP		MILLISECONDS
	MIN	EXP	JSON_ESCAPE		MINUTE
	REGR_AVGX	FLOOR	LEFT		MINUTES
	REGR_AVGY	FMOD	LENGTH		MONTH
	REGR_COUNT	LN	LOWER		MONTHS
	REGR_INTERCEPT	LOG10	LPAD		NOW
	REGR_R2	LOG2	LTRIM		PARSE_EPOCH
	REGR_SLOPE	PI	OCTET_LENGTH		PARSE_EPOCHRANGE
	REGR_SXX	POWER	ORD		PARSE_TP
	REGR_SXY	RADIANS	PARSE_BOOL		PARSE_TS
	REGR_SYY	RANDINT	PARSE_FLOAT		PARSE_TSRANGE
	STDDEV_POP	RANDOM	PARSE_INT		SECOND
	STDDEV_SAMP	ROUND	POSITION		SECONDS
	STRING_AGG	SIN	REPEAT		TO_CHAR
	SUM	SINH	REPLACE		TODAY
	VAR_POP	SQRT	REVERSE		TS_ADDM
	VAR_SAMP	TAN	RIGHT		TS_BUCKET
		TANH	RPAD		TS_DATE
		TRUNC	RTRIM		TS_DATETIME
			SPLIT_PART		TS_DAYSTART
			STARTS_WITH		TS_EXTRACT
			STRCMP		TS_ISOWEEKSTART
			SUBSTRING		TS_MONTHSTART
			TO_CHAR		TS_SUBM
			TRANSLATE		TS_TIMEOFDAY
			UPPER		TS_TRUNC
					TS_WEEKSTART
					TS_YEARSTART
					WEEK
					WEEKS
					YEAR
					YEARS
					YESTERDAY

Spatial Functions

Constructors	Conversions	Accessors	Predicates	Measurements	Processing	Coordinate conversions
ST_GEOGLINE	ST_ASBINARY	ST_BOUNDARY	ST_CONTAINS	ST_ANGLE	ST_AFFINE	TO_LAT
ST_GEOGPOINT	ST_ASTEXT	ST_ENDPOINT	ST_CONTAINSPROPERLY	ST_AREA	ST_BUFFER	TO_LON
ST_GEOGPOLYGON	ST_GEOGLINEFROMTEXT	ST_ENVELOPE	ST_COVEREDBY	ST_AZIMUTH	ST_CENTROID	TO_METERS
ST_LINE	ST_GEOGLINEFROMWKB	ST_EXPAND	ST_COVERS	ST_DISTANCE	ST_CLIP	TO_WORLD
ST_MAKEGEOGLINE	ST_GEOGMLINEFROMTEXT	ST_EXTERIORRING	ST_CROSSES	ST_DISTANCESPHERE	ST_CONVEXHULL	TO_WPX
ST_MAKEGEOGPOINT	ST_GEOGMLINEFROMWKB	ST_GEOMETRYN	ST_DFULLYWITHIN	ST_LENGTH	ST_DIFFERENCE	TO_WPY
ST_MAKEGEOGPOLYGON	ST_GEOGMPOINTFROMTEXT	ST_GEOMETRYTYPE	ST_DISJOINT	ST_LENGTHSPHERE	ST_INTERSECTION
ST_MAKELINE	ST_GEOGMPOINTFROMWKB	ST_INTERIORRINGN	ST_DWITHIN	ST_LONGESTLINE	ST_REVERSE
ST_MAKEPOINT	ST_GEOGMPOLYFROMTEXT	ST_ISEMPTY	ST_EQUALS	ST_MAXDISTANCE	ST_ROTATE
ST_MAKEPOLYGON	ST_GEOGMPOLYFROMWKB	ST_ISSIMPLE	ST_INTERSECTS	ST_PERIMETER	ST_SCALE
ST_POINT	ST_GEOGPOINTFROMTEXT	ST_ISVALID	ST_OVERLAPS		ST_SYMDIFFERENCE
ST_POLYGON	ST_GEOGPOINTFROMWKB	ST_ISVALIDREASON	ST_POINTINSIDECIRCLE		ST_TRANSLATE
	ST_GEOGPOLYGONFROMTEXT	ST_MEMSIZE	ST_RELATE		ST_TRANSSCALE
	ST_GEOGPOLYGONFROMWKB	ST_NPOINTS	ST_RELATION		ST_UNION
	ST_LINEFROMTEXT	ST_NUMGEOMETRIES	ST_TOUCHES
	ST_LINEFROMWKB	ST_NUMINTERIORRINGS	ST_WITHIN
	ST_MLINEFROMTEXT	ST_NUMPOINTS
	ST_MLINEFROMWKB	ST_POINTN
	ST_MPOINTFROMTEXT	ST_STARTPOINT
	ST_MPOINTFROMWKB	ST_X
	ST_MPOLYFROMTEXT	ST_XMAX
	ST_MPOLYFROMWKB	ST_XMIN
	ST_POINTFROMTEXT	ST_Y
	ST_POINTFROMWKB	ST_YMAX
	ST_POLYGONFROMTEXT	ST_YMIN
	ST_POLYGONFROMWKB
	ST_TOGEOG
	ST_TOGEOM