MONEY column showing .0000 for value 0... Used to be 0.00, kinda

execute in sql server management tools:

select cast(0 money) dollars;

0.00 result. receive php/mssl_* functions.

sql server driver php .0000

annoying. can it?

using v1.1 of driver w/sqlserver2008. affects display of returned in hundreds of stored procedures.

use code see in php:

$conn = sqlsrv_connect(...); $result = sqlsrv_query($conn, 'select cast(0 money) dollars;'); while($ar = sqlsrv_fetch_array($result, sqlsrv_fetch_assoc)) {     print_r($ar); }

not do. driver defines money data type decimal 4 digits @ right of decimal point. in line t-sql representation described at:

http://msdn.microsoft.com/en-us/library/ms179882.aspx

 

thanks,

serban

---

serban iliescu - msft

SQL Server  >  Microsoft Drivers for PHP for SQL Server