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

From: Date: Mon, 19 May 2003 14:49:03 +0000
Subject: #23699 [Opn->Csd]: mssql.datetimeconvert=0 option works randomly
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-39970@lists.php.net to get a copy of this message 
 ID:               23699
 Updated by:       derick@php.net
 Reported By:      tomasz at biznespolska dot pl
-Status:           Open
+Status:           Closed
 Bug Type:         MSSQL related
 Operating System: windows xp sp1
 PHP Version:      4.3.1
 New Comment:

This bug has been fixed in CVS.

In case this was a PHP problem, snapshots of the sources are packaged
every three hours; this change will be in the next snapshot. You can
grab the snapshot at http://snaps.php.net/.
 
In case this was a documentation problem, the fix will show up soon at
http://www.php.net/manual/.

In case this was a PHP.net website problem, the change will show
up on the PHP.net site and on the mirror sites in short time.
 
Thank you for the report, and for helping us make PHP better.




Previous Comments:
------------------------------------------------------------------------

[2003-05-19 09:36:23] tomasz at biznespolska dot pl

Using:
PHP Version 4.3.2-RC3-dev
has solved problem.

------------------------------------------------------------------------

[2003-05-19 09:13:13] 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-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

Thread (4 messages)

« previous php.bugs (#39970) next »