#23699 [NEW]: mssql.datetimeconvert=0 option works randomly

From: Date: Mon, 19 May 2003 14:03:04 +0000
Subject: #23699 [NEW]: mssql.datetimeconvert=0 option works randomly
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-39955@lists.php.net to get a copy of this message 
From:             tomasz at biznespolska dot pl
Operating system: windows xp sp1
PHP version:      4.3.1
PHP Bug Type:     MSSQL related
Bug description:  mssql.datetimeconvert=0 option works randomly

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 bug report at http://bugs.php.net/?id=23699&edit=1
-- 
Try a CVS snapshot:         http://bugs.php.net/fix.php?id=23699&r=trysnapshot
Fixed in CVS:               http://bugs.php.net/fix.php?id=23699&r=fixedcvs
Fixed in release:           http://bugs.php.net/fix.php?id=23699&r=alreadyfixed
Need backtrace:             http://bugs.php.net/fix.php?id=23699&r=needtrace
Try newer version:          http://bugs.php.net/fix.php?id=23699&r=oldversion
Not developer issue:        http://bugs.php.net/fix.php?id=23699&r=support
Expected behavior:          http://bugs.php.net/fix.php?id=23699&r=notwrong
Not enough info:            http://bugs.php.net/fix.php?id=23699&r=notenoughinfo
Submitted twice:            http://bugs.php.net/fix.php?id=23699&r=submittedtwice
register_globals:           http://bugs.php.net/fix.php?id=23699&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=23699&r=php3
Daylight Savings:           http://bugs.php.net/fix.php?id=23699&r=dst
IIS Stability:              http://bugs.php.net/fix.php?id=23699&r=isapi
Install GNU Sed:            http://bugs.php.net/fix.php?id=23699&r=gnused

Thread (4 messages)

« previous php.bugs (#39955) next »