|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPDO_DBLIB-force-format-of-datetime-fields (last revision 2011-11-15 13:23 UTC by steven dot lambeth at gmx dot de)Pull RequestsHistoryAllCommentsChangesGit/SVN commits
[2011-05-02 10:07 UTC] tomsommer@php.net
-Summary: PDO forces format of datetime fields
+Summary: PDO::MSSQL forces format of datetime fields
[2011-08-14 02:09 UTC] ssufficool at gmail dot com
[2013-02-12 16:45 UTC] d dot vergini at gameprog dot it
[2014-01-01 12:44 UTC] felipe@php.net
-Package: PDO related
+Package: PDO DBlib
[2014-10-25 04:46 UTC] ssufficool@php.net
-Assigned To:
+Assigned To: ssufficool
[2015-06-03 13:23 UTC] mirigoyen at icihomes dot com
[2016-02-29 16:08 UTC] ab@php.net
[2016-02-29 16:08 UTC] ab@php.net
-Status: Assigned
+Status: Closed
[2023-05-16 05:40 UTC] giw42161 at uooos dot com
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Thu Nov 21 15:01:30 2024 UTC |
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)