How to use scientific notation in a SELECT query mathematical operator?


#1

I tried using:
SELECT someField * 3.39472E-6 AS alias FROM someTable...
However it results in:

ERR: error parsing query: found E, expected FROM at line 1, char

Is it possible?


#2

Ah, I see now that they are not supported.