Edit report at https://bugs.php.net/bug.php?id=48908&edit=1
ID: 48908 Comment by: blyxx86 at gmail dot com Reported by: aaron at aarondm dot com Summary: Cannot query smalldatetime type columns Status: Open Type: Bug Package: MSSQL related Operating System: ArchLinux PHP Version: 5.2.10 Block user comment: N Private report: N New Comment: Also get this in PHP Version 5.3.2-1ubuntu4.14. Adding mssql.datetimeconvert = Off to php.ini does allow it to work. Previous Comments: ------------------------------------------------------------------------ [2011-09-14 17:40:11] me at abiusx dot com As described in http://php.net/manual/es/function.mssql-query.php comments, Adding mssql.datetimeconvert = Off in php.ini fixes the issue! ------------------------------------------------------------------------ [2011-06-30 04:55:10] Fr33z3m4n at gmx dot net Same Problem and is reproducable. Debian 2.6.26-26lenny1 PHP Version 5.3.6-12 Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies with Suhosin v0.9.32.1, Copyright (c) 2007-2010, by SektionEins GmbH ------------------------------------------------------------------------ [2010-07-20 11:51:29] tom dot lawton at kondor dot co dot uk PHP 5.2.4 / ubuntu 8.10LTS has this bug and is reproducable. Suhosin patch reports canary mismatch if a query returns smalldatetime. Apache does not trigger 500, nor does PHP report any error to the page - it dies silently. ------------------------------------------------------------------------ [2010-01-07 12:36:21] undicizeri at gmail dot com Same bug here. I'm using Ubuntu with php 5.2.6 and debian with php 5.2.12. ------------------------------------------------------------------------ [2009-12-21 11:22:41] php at mike2k dot com Sample query/workaround: old: SELECT acct_itm.cre_dtm AS cre_dtm new: SELECT CONVERT(varchar(10),acct_itm.cre_dtm,120) AS cre_dtm Not the most ideal. Might be a bug in the FreeTDS driver and not something PHP can handle but has to pass upstream. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=48908 -- Edit this bug report at https://bugs.php.net/bug.php?id=48908&edit=1
