Edit report at https://bugs.php.net/bug.php?id=48908&edit=1
ID: 48908 Comment by: me at abiusx 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: As described in http://php.net/manual/es/function.mssql-query.php comments, Adding mssql.datetimeconvert = Off in php.ini fixes the issue! Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2009-12-21 10:13:22] php at mike2k dot com Always repeatable. This is an issue for us as well. The previous comment is from a Windows user so they're probably able to leverage more native Windows MSSQL libraries... PHP 5.2.11, on Linux, using FreeTDS on CentOS 5.3 (or 5.4, not sure) x86_64 The workaround is having to cast the column inside of the query. I will try to post an example workaround query when I grab one from the dev team. Related Packages/versions of the driver, just in case: freetds-devel-0.64-11.el5.centos freetds-devel-0.64-6.el5 freetds-0.64-11.el5.centos freetds-0.64-6.el5 unixODBC-2.2.11-7.1 (32 bit) unixODBC-2.2.11-7.1 (64 bit) unixODBC-devel-2.2.11-7.1 (32 bit) unixODBC-devel-2.2.11-7.1 (64 bit) ------------------------------------------------------------------------ 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
