Hide Forgot
Description of problem: PHP began to receive wrong datetime values from mssql_query function after upgrading of freetds package. For example '2011-11-29 20:00:00' from database becomes '2011-04-11 00:03:20' in PHP. Downgrading this package back to the 0.64 version resolves this problem. Version-Release number of selected component (if applicable): freetds-0.91-1.el5.x86_64 How reproducible: I think it can be reproduced without any problems Steps to Reproduce: 1. Install freetds-0.91-1.el5.x86_64 2. Add mssql.datetimeconvert=Off to php.ini 3. Select any datetime value in PHP script from SQL Server database with mssql_query Actual results: The value will be distorted. Expected results: The same value as Microsoft SQL Server Management Studio shows. Additional info: SQL Server 10.50.1600.1 on Windows Server 2008 R2 Datacenter SP1 PHP 5.2.17 on CentOS 5.7
Well, Since the version of 0.84, "date format" defaults are changed for "default" and "en_US" locales in /etc/locales.conf: was: date format = %b %d %Y %I:%M%p now: date format = %b %e %Y %I:%M:%S:%z%p Try to revert the change (fe. as for es_ES locale) -- it should help you. If not, please, reopen this bug.