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: 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
Thread (10 messages)