Precision / MSSQL / smallmoney
| From: | Craig Cook | Date: | Mon, 06 May 2002 23:25:55 +0000 |
| Subject: | Precision / MSSQL / smallmoney | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18998@lists.php.net to get a copy of this message | ||
I had an interesting experience that I thought I would share.
In MSSQL 2000 I have a table with a column that is a "smallmoney" type with
a precision of 4.
In that column, one of the values that I have is ".3056". When I query that
value through PHP and the MSSQL commands, the value returned is ".31".
It would be nice to somehow query ".3056".
Not surprising, just thought I would add to the Vertical file.
Craig Cook