PostgreSQL/Math Functions/exponent
Select 4e3 AS exponential_float
postgres=# Select 4e3 AS exponential_float;
exponential_float
-------------------
4000
(1 row)
postgres=#
Select 6.1e-2 AS negative_exponent
postgres=# select 6.1e-2 AS negative_exponent;
negative_exponent
-------------------
0.061
(1 row)
postgres=#