Showing a lot of decimals
Posted: Wed 27 Apr 2016 15:46
Hi,
Making a query some fields contains a lot of decimals (field type NUMBER(13,6)) in this way:
Thanks
Making a query some fields contains a lot of decimals (field type NUMBER(13,6)) in this way:
Code: Select all
CAST(thefield AS FLOAT)
- result In dbForge for SQL Server: 0.35999999999999999
result in SQL Server Management Studio: 0.36
Thanks