Bug #48908 [Com]: Cannot query smalldatetime type columns
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
Thread (10 messages)