Floating Point

Floating point types include REAL (32 bit) and FLOAT or DOUBLE (both 64 bit). Floating point constants are specified as shown above for DECIMAL constants but they can also be specified exponentials as given in the syntax below.

float:
                [+ | -]digit...[.digit...]{E | e}[+ | -]digit[digit[digit]]

6.02E23
-3.776143e-12
1.0e+80
select * from mytypes where mytaxrate > 8.9e-2;