Showing a lot of decimals

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
andresm1
Posts: 1
Joined: Wed 27 Apr 2016 15:27

Showing a lot of decimals

Post by andresm1 » 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:

Code: Select all

CAST(thefield AS FLOAT)
  • result In dbForge for SQL Server: 0.35999999999999999
    result in SQL Server Management Studio: 0.36
is there any workaround for this?

Thanks

alexa

Re: Showing a lot of decimals

Post by alexa » Thu 28 Apr 2016 11:55

There is no such a possibility. However, we will implement it in one of the next product versions.

Post Reply