SqlDbx
You are not logged in.
Pages: 1
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
Offline
Thank for pointing this out. Will be addressed in an upcoming release
Offline
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
Offline
This issue is fixed in a latest version.
Offline
Thanks a lot!
Offline
Pages: 1