#22060 [Opn->Fbk]: mssql.datetimeconvert=0 gets wrong month
| From: | sniper@php.net | Date: | Wed, 05 Feb 2003 00:05:44 +0000 |
| Subject: | #22060 [Opn->Fbk]: mssql.datetimeconvert=0 gets wrong month | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-32152@lists.php.net to get a copy of this message | ||
ID: 22060
Updated by: sniper@php.net
Reported By: cunha17@uol.com.br
-Status: Open
+Status: Feedback
Bug Type: MSSQL related
Operating System: Linux 2.4
PHP Version: 4.3.0
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-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