#22060 [Opn->Bgs]: mssql.datetimeconvert=0 gets wrong month

ID: 22060 Updated by: fmk@php.net Reported By: cunha17@uol.com.br -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: Linux 2.4 PHP Version: 4.3.1-dev New Comment: Ok I can verify this then and it is not a bug in PHP. It is a bug in FreeTDS and I have asked for a fix. Previous Comments: ------------------------------------------------------------------------ [2003-02-09 14:16:48] cunha17@uol.com.br I´m running MSDE with SP5 on a Win98SE machine. I´m running PHP/Apache on a Linux machine with freetds. The type of the 'birth' column is datetime. ------------------------------------------------------------------------ [2003-02-09 02:53:18] fmk@php.net I need a bit more information to solve this. This can not be reproduced on my system. Are you using datetime or smalldatetime ? ------------------------------------------------------------------------ [2003-02-05 15:43:30] cunha17@uol.com.br same happened with php4-STABLE-200302052030. ------------------------------------------------------------------------ [2003-02-04 18:05:43] sniper@php.net 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 ------------------------------------------------------------------------ [2003-02-04 17:11:28] cunha17@uol.com.br >>When using this: $c = mssql_connect("172.16.0.1:1433", "hn", "hn"); mssql_select_db("hn"); $r = mssql_query("select * from hn.employee"); print_r(mssql_fetch_array($r)); >>I get this(as expected): Array ( [0] => M4398648MG [id] => M4398648MG [1] => FRED [nome] => FRED [2] => 105 roadhouse, av [addr] => 105 roadhouse, av [3] => NY [city] => NY [4] => NY [state] => NY [5] => 70272 [zip] => 70272 [6] => 280876 [id2] => 280876 [7] => FRED [nick] => FRED [8] => Mar 17 1973 12:00AM [birth] => Mar 17 1973 12:00AM ) >>When using this: ini_set('mssql.datetimeconvert',0); $c = mssql_connect("172.16.0.1:1433", "hn", "hn"); mssql_select_db("hn"); $r = mssql_query("select * from hn.employee"); print_r(mssql_fetch_array($r)); >>I get a wrong month number (02 instead of 03): Array ( [0] => M4398648MG [id] => M4398648MG [1] => FRED [nome] => FRED [2] => 105 roadhouse, av [addr] => 105 roadhouse, av [3] => NY [city] => NY [4] => NY [state] => NY [5] => 70272 [zip] => 70272 [6] => 280876 [id2] => 280876 [7] => FRED [nick] => FRED [8] => 1973-02-17 00:00:00 [birth] => 1973-02-17 00:00:00 ) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=22060&edit=1