I have 2 servers, each running the exact same version of PHP (5.3.5-1ubuntu7.8). They are also the exact same version of Ubuntu (11.04). I have written a PHP script to connect to a SQL Server 2008 R2 database, select a datetime value, and print_r() it to the screen.
When I run the script on one server, the datetime is returned in this format: 2011-08-20 00:00:00.000. When I run it on the other server, using the exact same script pulling from the same database record, I get this format: Aug 20 2011 12:00:00.000AM.
My problem is that I cannot figure out where the difference is on my servers that is causing the discrepancy in my datetime formats. I have played around with the mssql.datetimeconvert setting in the php.ini files for both Apache and the CLI, to no avail.
Has anybody encountered this issue before and determined what causes it? Any thoughts are extremely appreciated before I decide to just rebuild the servers. Thanks!