ReferenceSQL language referenceFunctionsBuilt-in functionsAlphabetical list of built-in functionsexpm1 functionOn this pageexpm1 function Applies to: Databricks SQL Databricks Runtime Returns exp(expr) - 1. Syntax expm1(expr) Arguments expr: An expression that evaluates to a numeric. Returns A DOUBLE. Examples SQL> SELECT expm1(0); 1.0 Related functions e function exp function