Skip to Content.
Sympa Menu

freetds - [freetds] tsql & money datatype

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Piet De Jong" <piet AT ahead-tech.net>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] tsql & money datatype
  • Date: Mon, 15 Nov 2004 17:11:54 +0200

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






Archive powered by MHonArc 2.6.24.

Top of Page