#23611 [Opn->Bgs]: mssql.datetimeconvert should not be on by default

From: Date: Tue, 13 May 2003 19:03:30 +0000
Subject: #23611 [Opn->Bgs]: mssql.datetimeconvert should not be on by default
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-39542@lists.php.net to get a copy of this message 
 ID:               23611
 Updated by:       fmk@php.net
 Reported By:      janko at dupoint dot com
-Status:           Open
+Status:           Bogus
 Bug Type:         MSSQL related
 Operating System: Windows 2000 Server
 PHP Version:      4.3.1
 New Comment:

Before this ini parameter was introduced the default behavior of the
extension was to convvert the dates. If we changed this we would break
a lot of code.


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

[2003-05-13 10:22:14] janko at dupoint dot com

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 this bug report at http://bugs.php.net/?id=23611&edit=1

Thread (7 messages)

« previous php.bugs (#39542) next »