FreeTDS Development Group

[James K. Lowden <jklowden AT speakeasy.org>]

On 15 Aug 2002 08:16:44 +0200, "Frediano Ziglio" <freddyz77 AT tin.it> wrote:

> Yesterday I did some test with tsql. Returning smallmoney (SYBMONEY4)
> print only 2 decimal digits but money4 have a precision of 4 decimal
> digits. It this intentional?
> 
> 1> select convert(smallmoney,'123.3456')
> 2> go
> 
> 123.34

It should display two digits, but rounded, not truncated.  tsql's display
choice isn't very important (it's meant for testing, not query writing),
but does sqsh do that?  
Here's Sybase:

1> select convert(smallmoney,'123.3456')
2> go
                          
 ------------------------ 
                   123.35 

(1 row affected)

--jkl