#20920 [Opn->Fbk]: mssql.datetimeconvert=0 doesn't work for smalldatetime

From: Date: Thu, 09 Jan 2003 18:22:42 +0000
Subject: #20920 [Opn->Fbk]: mssql.datetimeconvert=0 doesn't work for smalldatetime
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-29600@lists.php.net to get a copy of this message 
 ID:               20920
 Updated by:       fmk@php.net
 Reported By:      f.vulto@re-base.com
-Status:           Open
+Status:           Feedback
 Bug Type:         MSSQL related
 Operating System: Windows 2000
 PHP Version:      4CVS-2002-12-10 (dev)
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php4-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-latest.zip

The handling of boolean ini settings did not always work due to wrong
initialization of data types. This has been fixed in cvs.


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

[2002-12-10 05:39:48] f.vulto@re-base.com

When setting:

   ini_set('mssql.datetimeconvert', 0);

fields of type 'smalldatetime' are still converted to a
local date format.  The above setting only seems to apply
to fields of type 'datetime'.
For example, leaving 'mssql.datetimeconvert = 1' and
displaying two fields DATETIME and SMALLDATETIME would
result in:

   Dec 31 2002 12:00AM  // DATETIME
   Dec 31 2002 12:00AM  // SMALLDATETIME

whereas, setting 'mssql.datetimeconvert = 0' would result
in:

   2002-12-31 00:00:00  // DATETIME
   Dec 31 2002 12:00AM  // SMALLDATETIME

See also: http://bugs.php.net/bug.php?id=12655

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


-- 
Edit this bug report at http://bugs.php.net/?id=20920&edit=1

Thread (3 messages)

« previous php.bugs (#29600) next »