#23699 [Opn->Fbk]: mssql.datetimeconvert=0 option works randomly

ID: 23699 Updated by: sniper@php.net Reported By: tomasz at biznespolska dot pl -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: windows xp sp1 PHP Version: 4.3.1 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Previous Comments: ------------------------------------------------------------------------ [2003-05-19 09:03:03] tomasz at biznespolska dot pl I'm using: PHP 4.3.1 (as a module) Apache2.0.45 MS SQL Server 2000 (compatibility mode 70) Windows XP Pro Option mssql.datetimeconvert seems to work only randomly. This simple script produces different results, when I reload page few times: ini_set('mssql.datetimeconvert', 0); $re = mssql_connect('GANYMEDE\GANYMEDE', 'user', 'pass'); mssql_select_db('bp'); ini_set('mssql.datetimeconvert', 0); $sql = "SELECT TOP 10 addDate FROM c_content"; $re = mssql_query($sql); $row = mssql_fetch_array($re); ini_set('mssql.datetimeconvert', 0); echo ($row['addDate']); Once I get: "23 kwi 2003 14:11" other time: "2003-04-23 14:11:09" In this example addDate is datetime type. Function phpinfo() tells that mssql.datetimeconvert = 0 I have tried to turn off option datetimeconvert in php.ini file, and using ini_set() function. When I run php as cgi turning off this option doesn't work at all. Sorry for my english ;-) Regards, Tomasz Ulanowski ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=23699&edit=1