SqlDbx Forum

zluis0

Member

Show full decimal part

The money type fields only show two decimal places.

Example:

declare @value money

set @value = 56.3465

select @value
go

create table Example
(
  value money
)
go
insert into Example ( value ) values ( 56.3465 )
go
select value from Example
go

sqldbxhelp

Administrator

Re: Show full decimal part

Thank for pointing this out. Will be addressed in an upcoming release

Bulanov A.

Member

Re: Show full decimal part

Rounding issue can be fixed via settings. Options -> Results -> Max Decimal = No rounding.
But there is a problem when money value is less then 0.1

select convert(money, 0.0123), convert(money, -0.0123), convert(money, 0.123), convert(money, -0.123), @@VERSION

Results in

No Column Name No Column Name No Column Name No Column Name No Column Name                                                                                                           
-------------- -------------- -------------- -------------- --------------------------------------------------------------------------------------------------------------------------
           123         0.-123         0.1230        -0.1230 Adaptive Server Enterprise/12.5.4/EBF 15446 ESD#8/P/Solaris AMD64/OS 5.10/ase1254/2105/64-bit/OPT/Sat Mar 22 04:05:46 2008

sqldbxhelp

Administrator

Re: Show full decimal part

This issue is fixed in a latest version.

Bulanov A.

Member

Re: Show full decimal part

Thanks a lot!