By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select CAST('5.915675775e-17' AS decimal )
| CAST('5.915675775e-17' AS decimal ) |
|---|
| 0 |
select CAST('5.915675775e-17' AS double)
| CAST('5.915675775e-17' AS double) |
|---|
| 5.915675775e-17 |
select CAST('5.915675775e-17' AS float)
| CAST('5.915675775e-17' AS float) |
|---|
| 5.91568e-17 |
select CAST('5.915675775e-17' AS real)
| CAST('5.915675775e-17' AS real) |
|---|
| 5.915675775e-17 |