Math
Snowflake
EXP
Menghitung e pangkat x (exponential function).
Tipe hasil:
DOUBLEDiperbarui: 6 Jan 2026Syntax
SQL
EXP(numeric_expression)Parameter
numeric_expressionnumericwajib
Pangkat untuk e (~2.71828)
Contoh Penggunaan
Exponential
SQL
1 SELECT EXP(1) as result;
e pangkat 1 = e.
Hasil
2.718281828...
Continuous Compounding
SQL
1 SELECT principal * EXP(rate * time) as value 2 FROM investments;
Continuous compound interest.