SQL Dialects Reference/Functions and expressions/Misc expressions

Misc functions Convert value val to data type type CAST(val AS type) CAST(val AS type)val::type sql-expressions.html#SQL-SYNTAX-TYPE-CASTS CAST(val AS type) CAST(val AS type) functions016.htm CAST(val AS type)CONVERT(type, val, style) 187928 CAST(val AS type)CASTexpression as typeTO_CHARTO_NUMBERTO_DATE CONVERT(val, type)CAST(val AS type) cast-functions.html#function_convert CAST(val AS type)CONVERT(val, type) CAST(val AS type) lang_expr.html#castexpr Replace NULL within a val with a fallback value, return val intact, if it's non-NULL F261-04 COALESCE(val, fallback) COALESCE(val, fallback)ISNULL(val, fallback) 184325 IFNULL(val, fallback) control-flow-functions.html#function_ifnull COALESCE(val, fallback) COALESCE(val, fallback)NVL(val, fallback) functions105.htm NVL(val, fallback) COALESCE(val, fallback) IFNULL(val, fallback)COALESCE(val, fallback) corefunc.html#ifnull functions-conditional.html#AEN13109 Return the first non-NULL value from a list of values (val1, val2, ...) F261-04 COALESCE(val1, val2, ...) COALESCE(val1, val2) COALESCE(val1, val2, ...) comparison-operators.html#function_coalesce COALESCE(val1, val2, ...) COALESCE(val1, val2, ...) functions-conditional.html#AEN13109 COALESCE(val1, val2, ...) COALESCE(val1, val2, ...) functions023.htm COALESCE(val1, val2, ...) 190349 COALESCE(val1, val2, ...) COALESCE(val1, val2, ...) lang_corefunc.html#coalesce Convert particular values to NULL: return NULL if a = b otherwise keep a NULLIF(a, b) NULLIF(a, b) functions-conditional.html#AEN13130 NULLIF(a, b) NULLIF(a, b) functions107.htm NULLIF(a, b) NULLIF(a, b) NULLIF(a, b) control-flow-functions.html#function_nullif NULLIF(a, b) NULLIF(a, b) corefunc.html#nullif |}