Bug #16403 Updated: datetime field error

ID: 16403 Updated by: sniper@php.net Reported By: lhling_99@yahoo.com -Status: Open +Status: Closed Bug Type: MSSQL related Operating System: windows NT 4.0 PHP Version: 4.0.5 New Comment: Please try PHP 4.2.0 and reopen if this problem still exists in it. Previous Comments: ------------------------------------------------------------------------ [2002-04-23 14:07:01] mbretter@jawa.at one of the latest version of php_mssql.c php_mssql.h have a patch for this problem, because the function dbconvert() of the MSSQL-Client-Api wich is used for converting the datetime-values does wired things. There is a new option in the php.ini called mssql.datetimeconvert if set to Off then the datetime values are returned in the format YYYY-MM-DD HH:MM:SS. This patch is also in php4.2 ------------------------------------------------------------------------ [2002-04-03 19:54:08] lhling_99@yahoo.com what does it mean by "reclassified" ? ------------------------------------------------------------------------ [2002-04-03 08:42:05] sniper@php.net reclassified ------------------------------------------------------------------------ [2002-04-03 00:21:39] lhling_99@yahoo.com I'm using PHP 4.0.5 with Microsoft SQL Server 6.5 in Windows NT 4.0 platform. When I try to select a "datetime" field in a record, the result is a truncated date like "Oct 10 2". ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=16403&edit=1