Bug #54648 [NEW]: PDO forces format of datetime fields

From: Operating system: Linux PHP version: 5.3.6 Package: PDO related Bug Type: Bug Bug description:PDO forces format of datetime fields Description: ------------ The PDO::MSSQL layer forces a format upon datetime fields, which cannot be altered. The MSSQL extension does not. mssql.datetimeconvert apparently has no effect on PDO. Test script: --------------- ini_set('mssql.datetimeconvert', 0); $sql = mssql_query("SELECT GETDATE()"); var_dump(mssql_fetch_assoc($sql)); var_dump($mssql->query("SELECT GETDATE()")->fetch()); Expected result: ---------------- array 'computed' => string '2011-05-02 10:02:08' (length=19) array 'computed' => string '2011-05-02 10:02:08' (length=19) 0 => string '2011-05-02 10:02:08' (length=19) Actual result: -------------- array 'computed' => string '2011-05-02 10:02:08' (length=19) array 'computed' => string 'maj 02 2011 10:02:08' (length=20) 0 => string 'maj 02 2011 10:02:08' (length=20) -- Edit bug report at http://bugs.php.net/bug.php?id=54648&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=54648&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=54648&r=trysnapshot53 Try a snapshot (trunk): http://bugs.php.net/fix.php?id=54648&r=trysnapshottrunk Fixed in SVN: http://bugs.php.net/fix.php?id=54648&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=54648&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=54648&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=54648&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=54648&r=needscript Try newer version: http://bugs.php.net/fix.php?id=54648&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=54648&r=support Expected behavior: http://bugs.php.net/fix.php?id=54648&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=54648&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=54648&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=54648&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=54648&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=54648&r=dst IIS Stability: http://bugs.php.net/fix.php?id=54648&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=54648&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=54648&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=54648&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=54648&r=mysqlcfg