#23611 [NEW]: mssql.datetimeconvert should not be on by default

From: Date: Tue, 13 May 2003 15:22:14 +0000
Subject: #23611 [NEW]: mssql.datetimeconvert should not be on by default
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-39532@lists.php.net to get a copy of this message 
From:             janko at dupoint dot com
Operating system: Windows 2000 Server
PHP version:      4.3.1
PHP Bug Type:     MSSQL related
Bug description:  mssql.datetimeconvert should not be on by default

One thing that puzzled me and my co-workers for the 
longest of time is that MSSQL flat out refused to 
return dates in any sensible form, but insisted on 
returning them 'formatted' - in Swedish (the server's 
locale).

Now, on certain months (Januari - jan; februari - feb) 
this would at least work, although we lost precision as 
it would only return minutes, not seconds.

On other months (Maj - maj, Oktober - okt), we suddenly 
couldn't enter into the database what it had given us, 
because it didn't understand what it seemingly just 
gave us.

We were just about to go through a major overhaul of 
our application due to this problem, which would have 
cost us insane amounts of time and money, when we 
almost accidentally stumbled over the ini setting 
mssql.datetimeconvert. Turn it off, and hey - over a 
year of frustration ends.

I think it goes without saying that this ini variable 
should _not_ be turned on in a default installation.
-- 
Edit bug report at http://bugs.php.net/?id=23611&edit=1
-- 
Try a CVS snapshot:         http://bugs.php.net/fix.php?id=23611&r=trysnapshot
Fixed in CVS:               http://bugs.php.net/fix.php?id=23611&r=fixedcvs
Fixed in release:           http://bugs.php.net/fix.php?id=23611&r=alreadyfixed
Need backtrace:             http://bugs.php.net/fix.php?id=23611&r=needtrace
Try newer version:          http://bugs.php.net/fix.php?id=23611&r=oldversion
Not developer issue:        http://bugs.php.net/fix.php?id=23611&r=support
Expected behavior:          http://bugs.php.net/fix.php?id=23611&r=notwrong
Not enough info:            http://bugs.php.net/fix.php?id=23611&r=notenoughinfo
Submitted twice:            http://bugs.php.net/fix.php?id=23611&r=submittedtwice
register_globals:           http://bugs.php.net/fix.php?id=23611&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=23611&r=php3
Daylight Savings:           http://bugs.php.net/fix.php?id=23611&r=dst
IIS Stability:              http://bugs.php.net/fix.php?id=23611&r=isapi
Install GNU Sed:            http://bugs.php.net/fix.php?id=23611&r=gnused

Thread (7 messages)

« previous php.bugs (#39532) next »