|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2010-05-20 14:10 UTC] mike@php.net
-Status: Open
+Status: Feedback
[2010-05-20 14:10 UTC] mike@php.net
[2010-05-20 15:17 UTC] corey dot barnes at verizon dot com
-Status: Feedback
+Status: Open
-PHP Version: 5.2.13
+PHP Version: 5.1.6
[2010-05-20 15:17 UTC] corey dot barnes at verizon dot com
[2010-06-03 17:56 UTC] rgagnon24 at gmail dot com
[2010-06-03 18:01 UTC] rgagnon24 at gmail dot com
[2010-06-27 00:22 UTC] felipe@php.net
-Summary: date format
+Summary: PDO Informix - date format
[2010-08-20 17:38 UTC] kalle@php.net
-Status: Open
+Status: Closed
-Assigned To:
+Assigned To: kalle
[2010-08-20 17:38 UTC] kalle@php.net
|
|||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Tue Dec 02 13:00:01 2025 UTC |
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