> ## Documentation Index > Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # SQL Expressions in Magic ETL | Reference ### Intro This reference lists the available SQL expressions in Magic ETL. For a description and more information about a specific expression, see the Magic ETL UI. Learn how to use these expressions in the [SQL tile](https://domo-support.domo.com/s/article/360044876874?language=en_US#sql_tile) while creating a Magic ETL DataFlow. ***

Expression Name	Syntax	Category	Available for Magic on Cloud Compute?
!	! cond	LOGIC	Y
!=	X!= Y	LOGIC	Y
!\~	X!\~ Y	STRING	-
!\~\*	X!\~\* Y	STRING	-
()	(expr)	NUMERIC	Y
\*	X \* Y	NUMERIC	Y
'+	X + Y	NUMERIC	Y
-	X - Y	NUMERIC	Y
/	X / Y	NUMERIC	Y
::	expr::TYPE	LOGIC	Y
\<	X \< Y	LOGIC	Y
\<=	X \<= Y	LOGIC	Y
\<=>	X \<=> Y	LOGIC	-
\<>	X \<> Y	LOGIC	Y
'=	X = Y	LOGIC	Y
>	X > Y	LOGIC	Y
>=	X >= Y	LOGIC	Y
ABS	ABS(X)	NUMERIC	Y
ACOS	ACOS(X)	NUMERIC	-
ADDDATE	ADDDATE(date,INTERVAL expr unit)	TIME	Y
ADDTIME	ADDTIME(expr1,expr2)	TIME	Y
AND	cond1 AND cond2	LOGIC	Y
ANOVAF	ANOVAF(sample1,sample2\[,sample3\[,...,sampleN]])	STATISTICAL	-
ANOVAP	ANOVAP(sample1,sample2\[,sample3\[,...,sampleN]])	STATISTICAL	-
APPROXIMATE\_COUNT\_DISTINCT	APPROXIMATE\_COUNT\_DISTINCT(X)	NUMERIC	Y
ASIN	ASIN(X)	NUMERIC	-
ATAN	ATAN(X)	NUMERIC	-
ATAN2	ATAN2(Y,X)	NUMERIC	-
AVG	AVG(expr)	NUMERIC	Y
BETWEEN	expr1 BETWEEN expr2 AND expr3	LOGIC	Y
BIT\_AND	BIT\_AND(X, Y)	NUMERIC	-
BIT\_LSHIFT	BIT\_LSHIFT(X, Y)	NUMERIC	-
BIT\_NAND	BIT\_NAND(X, Y)	NUMERIC	-
BIT\_NOR	BIT\_NOR(X, Y)	NUMERIC	-
BIT\_NOT	BIT\_NOT(X)	NUMERIC	-
BIT\_OR	BIT\_OR(X, Y)	NUMERIC	-
BIT\_RSHIFT	BIT\_RSHIFT(X, Y)	NUMERIC	-
BIT\_XNOR	BIT\_XNOR(X, Y)	NUMERIC	-
BIT\_XOR	BIT\_XOR(X, Y)	NUMERIC	-
BOOLEAN	BOOLEAN(expr)	LOGIC	-
CASE	CASE WHEN cond1 THEN expr1 WHEN condN THEN exprN ELSE elseExpr END	LOGIC	Y
CAST	CAST(expr AS type)	LOGIC	Y
CBRT	CBRT(X)	NUMERIC	-
CEIL	CEIL(X)	NUMERIC	Y
CEILING	CEILING(X)	NUMERIC	Y
CHAR\_LENGTH	CHAR\_LENGTH(str)	STRING	Y
COALESCE	COALESCE(value,...)	LOGIC	Y
CONCAT	CONCAT(str1,str2,...)	STRING	Y
CONV	CONV(N,from\_base,to\_base)	NUMERIC	-
CONVERT\_TZ	CONVERT\_TZ(dt,from\_tz,to\_tz)	TIME	Y
CONVERT\_UNIT	CONVERT\_UNIT(expr,from\_unit,to\_unit)	NUMERIC	-
CORR	CORR(x,y)	STATISTICAL	-
COS	COS(X)	NUMERIC	-
COSH	COSH(X)	NUMERIC	-
COT	COT(X)	NUMERIC	-
COUNT	COUNT(expr)	NUMERIC	Y
COUNT\_DISTINCT	COUNT\_DISTINCT(expr)	NUMERIC	Y
COVAR\_POP	COVAR\_POP(x,y)	STATISTICAL	-
COVAR\_SAMP	COVAR\_SAMP(x,y)	STATISTICAL	-
CRC32	CRC32(expr)	NUMERIC	-
CURDATE	CURDATE()	TIME	Y
CURDATETIME	CURDATETIME()	TIME	Y
CURRENT\_DATE	CURRENT\_DATE()	TIME	Y
CURRENT\_TIME	CURRENT\_TIME()	TIME	Y
CURRENT\_TIMESTAMP	CURRENT\_TIMESTAMP()	TIME	Y
CURTIME	CURTIME()	TIME	Y
DATE	DATE(expr)	TIME	Y
DATEDIFF	DATEDIFF(\[unit,]expr1,expr2)	TIME	Y
DATETIME	DATETIME(expr)	TIME	Y
DATE\_ADD	DATE\_ADD(date,INTERVAL expr unit)	TIME	Y
DATE\_FORMAT	DATE\_FORMAT(date, format)	TIME	Y
DATE\_SUB	DATE\_SUB(date,INTERVAL expr unit)	TIME	Y
DATE\_TRUNC	DATE\_TRUNC(precision, date)	TIME	Y
DATE\_WORKING\_DIFF	DATE\_WORKING\_DIFF(expr1,expr2)	TIME	-
DAY	DAY(date)	TIME	Y
DAYNAME	DAYNAME(date)	TIME	Y
DAYOFMONTH	DAYOFMONTH(date)	TIME	Y
DAYOFWEEK	DAYOFWEEK(date)	TIME	Y
DAYOFYEAR	DAYOFYEAR(date)	TIME	Y
DECIMAL	DECIMAL(expr)	NUMERIC	Y
DEGREES	DEGREES(X)	NUMERIC	-
DISTANCE	DISTANCE(lat0, lon0, lat1, lon1)	NUMERIC	-
DISTANCEV	DISTANCEV(lat0, lon0, lat1, lon1)	NUMERIC	-
DIV	DIV(X,Y)	NUMERIC	Y
DOUBLE	DOUBLE(expr)	NUMERIC	Y
DURATION	DURATION(expr)	TIME	-
DX\_ACTION\_ID	'@@DX\_ACTION\_ID	SYSTEM	-
DX\_ACTION\_NAME	'@@DX\_ACTION\_NAME	SYSTEM	-
DX\_DATAFLOW\_ID	'@@DX\_DATAFLOW\_ID	SYSTEM	-
DX\_DATAFLOW\_NAME	'@@DX\_DATAFLOW\_NAME	SYSTEM	-
DX\_ENGINE	'@@DX\_ENGINE	SYSTEM	-
DX\_EXECUTION\_ID	'@@DX\_EXECUTION\_ID	SYSTEM	-
DX\_IS\_PREVIEW	'@@DX\_IS\_PREVIEW	SYSTEM	-
DYNACAST	DYNACAST(expr, type\_expr)	STRING	Y
E	E()	NUMERIC	-
EPOCH\_MILLIS	EPOCH\_MILLIS(\[timestamp])	TIME	-
ERROR	ERROR(error\_string)	LOGIC	-
EXP	EXP(X)	NUMERIC	-
EXPRESS	EXPRESS(expr,substitution1,substitution2,...)	LOGIC	-
EXPRESSION	EXPRESS(expr)	LOGIC	-
EXPR\_COLUMN	EXPR\_COLUMN(str)	LOGIC	-
EXPR\_FORMAT	EXPR\_FORMAT	LOGIC	-
EXPR\_PARSE	EXPR\_PARSE(str)	LOGIC	-
EXPR\_PUSH	EXPR\_PUSH(expr,substitution)	LOGIC	-
EXPR\_VALUE	EXPR\_VALUE(expr)	LOGIC	-
EXTRACT	EXTRACT(field FROM expr)	TIME	Y
FINITE	FINITE(expr)	NUMERIC	-
FIRST\_NON\_NULL\_VALUE	FIRST\_NON\_NULL\_VALUE(expr)	LOGIC	Y
FIRST\_VALUE	FIRST\_VALUE(expr)	LOGIC	Y
FLOOR	FLOOR(X)	NUMERIC	Y
FROM\_BASE64	FROM\_BASE64(str)	STRING	-
FROM\_DAYS	FROM\_DAYS(N)	TIME	Y
FROM\_EPOCH\_MILLIS	FROM\_EPOCH\_MILLIS(epoch\_millis)	TIME	-
FROM\_UNIXTIME	FROM\_UNIXTIME(unix\_timestamp)	TIME	Y
FUZZY\_PARSE\_DATE	FUZZY\_PARSE\_DATE(str)	TIME	-
FV	FV(rate,nper,pmt\[,pv\[,type]])	FINANCIAL	-
GREATEST	GREATEST(value,...)	LOGIC	-
GROUP\_CONCAT	GROUP\_CONCAT(\[DISTINCT] str1,str2,...\[SEPARATOR sep])	STRING	Y
HOUR	HOUR(time)	TIME	Y
IFERROR	IFERROR(expr1,expr2)	LOGIC	-
IFNULL	IFNULL(expr1,expr2)	LOGIC	Y
IN	expr1 IN (expr2,expr3,...)	LOGIC	Y
INFINITY	INFINITY()	NUMERIC	-
INITCAP	INITCAP(str)	STRING	Y
INSTR	INSTR(str,substr)	STRING	Y
IRR	IRR(values\[,guess])	FINANCIAL	-
IS NULL	expr IS NULL	LOGIC	Y
LAST\_DAY	LAST\_DAY(date)	TIME	Y
LAST\_NON\_NULL\_VALUE	LAST\_NON\_NULL\_VALUE(expr)	LOGIC	Y
LAST\_VALUE	LAST\_VALUE(expr)	LOGIC	Y
LCASE	LCASE(str)	STRING	Y
LEAST	LEAST(value,...)	LOGIC	-
LEFT	LEFT(str,len)	STRING	Y
LENGTH	LENGTH(str)	STRING	Y
LISTAGG	LISTAGG(str1\[,sep])	STRING	Y
LN	LN(X)	NUMERIC	-
LOCALE	'@@LOCALE	TIME	-
LOG	LOG(\[B,]X)	NUMERIC	-
LOG10	LOG10(X)	NUMERIC	-
LOG2	LOG2(X)	NUMERIC	-
LONG	LONG(expr)	NUMERIC	Y
LONG\_MAX	LONG\_MAX()	NUMERIC	-
LONG\_MIN	LONG\_MIN()	NUMERIC	-
LOWER	LOWER(str)	STRING	Y
LPAD	LPAD(str, len, padstr)	STRING	Y
LTRIM	LTRIM(str)	STRING	Y
MAX	MAX(expr)	NUMERIC	Y
MD5	MD5(expr1,expr2...,exprN)	NUMERIC	-
MEDIAN	MEDIAN(expr)	STATISTICAL	Y
MICROSECOND	MICROSECOND(expr)	TIME	Y
MILLISECOND	MILLISECOND(expr)	TIME	Y
MIN	MIN(expr)	NUMERIC	Y
MINUTE	MINUTE(time)	TIME	Y
MOD	MOD(N,M)	NUMERIC	Y
MONTH	MONTH(date)	TIME	Y
MONTHNAME	MONTHNAME(date)	TIME	Y
NAN	NAN()	NUMERIC	-
NEGATIVE\_INFINITY	NEGATIVE\_INFINITY()	NUMERIC	-
NOT	NOT cond	LOGIC	Y
NOW	NOW()	TIME	Y
NPER	NPER(rate,pmt,pv\[,fv\[,type]])	FINANCIAL	-
NPV	NPV(rate,values)	FINANCIAL	-
NULL	NULL	LOGIC	Y
NULLIF	NULLIF(expr1,expr2)	LOGIC	Y
OCTET\_LENGTH	OCTET\_LENGTH(str)	STRING	Y
OR	cond1 OR cond2	LOGIC	Y
PERCENTILE	PERCENTILE(expr, ntile)	STATISTICAL	Y
PERIOD	PERIOD(expr)	TIME	-
PERIOD\_ADD	PERIOD\_ADD(P,N)	TIME	Y
PERIOD\_DIFF	PERIOD\_DIFF(P1,P2)	TIME	Y
PI	PI()	NUMERIC	-
PMT	PMT(rate,nper,pv\[,fv\[,type]])	FINANCIAL	-
POW	POW(X,Y)	NUMERIC	Y
POWER	POWER(X,Y)	NUMERIC	Y
PV	PV(rate,nper,pmt\[,fv\[,type]])	FINANCIAL	-
QUARTER	QUARTER(date)	TIME	Y
RADIANS	RADIANS(X)	NUMERIC	-
RAND	RAND(\[N])	NUMERIC	Y
RATE	RATE(rate,nper,pv\[,fv\[,type\[,guess]]])	FINANCIAL	-
REGEXP	X REGEXP Y	STRING	-
REGEXP\_LIKE	REGEXP\_LIKE(str,pat\[,flags])	STRING	-
REGEXP\_REPLACE	REGEXP\_REPLACE(str,pat,repl\[,flags])	STRING	Y
REPLACE	REPLACE(str,from\_str,to\_str)	STRING	Y
REVERSE	REVERSE(str)	STRING	-
RIGHT	RIGHT(str,len)	STRING	Y
RLIKE	X RLIKE Y	STRING	-
ROUND	ROUND(X\[,D])	NUMERIC	Y
ROW\_NUMBER	ROW\_NUMBER()	LOGIC	Y
RPAD	RPAD(str, len, padstr)	NUMERIC	Y
RTRIM	RTRIM(str)	NUMERIC	Y
SECOND	SECOND(time)	TIME	Y
SEC\_TO\_TIME	SEC\_TO\_TIME(seconds)	TIME	Y
SHA1	SHA1(expr1,expr2...,exprN)	NUMERIC	-
SIGN	SIGN(X)	NUMERIC	-
SIN	SIN(X)	NUMERIC	-
SINH	SINH(X)	NUMERIC	-
SPLIT\_PART	SPLIT\_PART(str,sep,N)	STRING	Y
SQRT	SQRT(X)	NUMERIC	Y
SQUASH\_WHITESPACE	SQUASH\_WHITESPACE(str)	STRING	Y
STD	STD(expr)	STATISTICAL	Y
STDDEV	STDDEV(expr)	STATISTICAL	Y
STDDEV\_POP	STDDEV\_POP(expr)	STATISTICAL	Y
STDDEV\_SAMP	STDDEV\_SAMP(expr)	STATISTICAL	Y
STRING	STRING(expr)	STRING	Y
STR\_CONTAINS	STR\_CONTAINS(str, search)	STRING	Y
STR\_DIGITS	STR\_DIGITS(str)	STRING	Y
STR\_ENDS\_WITH	STR\_ENDS\_WITH(str, search)	STRING	Y
STR\_NORMALIZE	STR\_NORMALIZE(str)	STRING	-
STR\_REMOVE\_DIGITS	STR\_REMOVE\_DIGITS(str)	STRING	Y
STR\_STARTS\_WITH	STR\_STARTS\_WITH(str, search)	STRING	Y
STR\_TO\_CHARNAMES	STR\_TO\_CHARNAMES(str)	STRING	-
STR\_TO\_DATE	STR\_TO\_DATE(str,format)	TIME	Y
STR\_TO\_HEX	STR\_TO\_HEX(str)	STRING	-
SUBDATE	SUBDATE(date,INTERVAL expr unit)	TIME	Y
SUBSTRING	SUBSTRING(str,pos\[,len])	STRING	Y
SUBSTRING\_INDEX	SUBSTRING\_INDEX(src,delimiter,count)	STRING	-
SUBTIME	SUBTIME(expr1,expr2)	TIME	Y
SUM	SUM(expr)	NUMERIC	Y
SYSDATE	SYSDATE()	TIME	Y
SYSTEM\_LOCALE	'@@SYSTEM\_LOCALE	TIME	-
SYSTEM\_TZ	'@@SYSTEM\_TZ	TIME	-
TAN	TAN(X)	NUMERIC	-
TANH	TANH(X)	NUMERIC	-
TIME	TIME(expr)	TIME	Y
TIMEDIFF	TIMEDIFF(expr1,expr2)	TIME	Y
TIMESTAMP	TIMESTAMP(expr)	TIME	Y
TIMESTAMP\_TRUNC	TIMESTAMP\_TRUNC(timestamp\[,precision])	TIME	Y
TIME\_FORMAT	TIME\_FORMAT(time,format)	TIME	Y
TIME\_TO\_SEC	TIME\_TO\_SEC(time)	TIME	Y
TODAY	TODAY()	TIME	Y
TO\_BASE64	TO\_BASE64(str)	STRING	-
TO\_DAYS	TO\_DAYS(date)	TIME	Y
TRIM	TRIM(\[\{BOTH \| LEADING \| TRAILING} \[remstr] FROM] str)	TIME	Y
TRUNC	TRUNC(timestamp\[,precision])	TIME	Y
TRUNCATE	TRUNCATE(X,D)	NUMERIC	Y
TRY\_CAST	TRY\_CAST(expr AS type)	LOGIC	-
TTEST	TTEST(sample1,sample2,tails,type)	STATISTICAL	-
TZ	'@@TZ	TIME	-
UCASE	UCASE(str)	STRING	Y
UNIX\_TIMESTAMP	UNIX\_TIMESTAMP(\[date])	TIME	Y
UPPER	UPPER(str)	STRING	Y
VARIANCE	VARIANCE(expr)	STATISTICAL	Y
VARIANCE\_POP	VARIANCE\_POP(expr)	STATISTICAL	Y
VARIANCE\_SAMP	VARIANCE\_SAMP(expr)	STATISTICAL	Y
VAR\_POP	VAR\_POP(expr)	STATISTICAL	Y
VAR\_SAMP	VAR\_SAMP(expr)	STATISTICAL	Y
WEEK	WEEK(date\[,mode])	TIME	Y
WEEKDAY	WEEKDAY(date)	TIME	Y
WEEKOFYEAR	WEEKOFYEAR(date\[,mode])	TIME	Y
WIDTH\_BUCKET	WIDTH\_BUCKET(expr, min, max, bucket\_count)	NUMERIC	Y
XIRR	XIRR(values,dates\[,guess])	FINANCIAL	-
XNPV	XNPV(rate,values,dates)	FINANCIAL	-
XOR	cond1 XOR cond2	LOGIC	-
YEAR	YEAR(date)	TIME	Y
YEARWEEK	YEARWEEK(date\[,mode])	TIME	Y
\~	X \~ Y	STRING	-
\~\*	X \~\* Y	STRING	-