Edit report at http://bugs.php.net/bug.php?id=51863&edit=1
ID: 51863 Updated by: [email protected] Reported by: corey dot barnes at verizon dot com Summary: PDO Informix - date format -Status: Open +Status: Closed Type: Bug Package: PDO related Operating System: RHEL 5 - linux PHP Version: 5.1.6 -Assigned To: +Assigned To: kalle Block user comment: N New Comment: PDO Informix is not maintained in core anymore, please report it to the IBM guys at pecl.php.net, thanks Previous Comments: ------------------------------------------------------------------------ [2010-06-03 18:01:26] rgagnon24 at gmail dot com Another thing I just thought about. If the date format were to be changed now, it would break compatibility with existing PHP code. ------------------------------------------------------------------------ [2010-06-03 17:56:47] rgagnon24 at gmail dot com This could be to keep the date format standard among all PDO drivers, so code does not need to be aware of the database storage types. Also, pdo_informix is a PECL extension. Should this be an issue for PECL? ------------------------------------------------------------------------ [2010-05-20 15:17:54] corey dot barnes at verizon dot com This is not dependent on a server setting. I can query using IFX functions (for INFORMIX) and the date is returned in the correct format, but when I use the PDO functions it returns as yyyy-mm-dd (instead of mm/dd/yyyy). ------------------------------------------------------------------------ [2010-05-20 14:10:35] [email protected] Hi, is this by any chance dependent on your locale, or on a date output format setting of the server? ------------------------------------------------------------------------ [2010-05-19 22:52:45] corey dot barnes at verizon dot com Description: ------------ When using the PDO connection option to an Informix data base the date is returned in the format YYYY-MM-DD instead of in the format that it is stored in the database. Test script: --------------- try { $pdo=new PDO('informix:host=$host; database=$db; server=$server; protocol=onsoctcp;',"","",array(PDO::ATTR_PERSISTENT=>true)); } catch (PDOexception $e) { echo "Failed to get DB handle: " . $e->getMessage() . "\n"; exit; } $sql = "SELECT dba_date,due_date FROM work_requests Where work_id='6862105'"; $q = $pdo->prepare($sql); $q->execute(); $q->setFetchMode(PDO::FETCH_BOTH); while($sqlr = $q->fetch()){ print $sqlr['DBA_DATE'] ."<br>"; print $sqlr['DUE_DATE'] ."<br>"; } Expected result: ---------------- mm/dd/yyyy Actual result: -------------- yyyy-mm-dd ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=51863&edit=1
