FreeTDS Development Group

["Piet De Jong" <piet AT ahead-tech.net>]

Hi all,
just doing some tests on tsql, and get some surprising/unexpected
results.
The money datatype only seems to return 2 decimal places ? whereas in
sql query analyzer it does return 4.
Any ideas ?
 
Here follows the output, notice there are only 2 digits for the money
datatype..
 
1> select 1.0001
2> go
 
1.0001
1> select cast ( 1.0001 as money)
2> go
 
1.00
1> select cast ( 1.0001 as decimal(19,4) )
2> go
 
1.0001