|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2008-08-22 09:18 UTC] cgourion at yahoo dot fr
[2008-08-28 08:11 UTC] opendev at us dot ibm dot com
[2008-11-11 06:39 UTC] abhargav at in dot ibm dot com
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Oct 26 03:00:01 2025 UTC |
Description: ------------ Select interval value is right shifted "12:34:56" - value in DB : INTERVAL HOUR TO SECOND pdo_informix return as " 12:34:5" Datetime work OK Reproduce code: --------------- echo "<PRE>"; $db = new PDO("informix: database=dbxy; server=ds0_vyvoj"); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->exec("CREATE TEMP TABLE ttt ( col1 interval hour to second ) "); $db->exec("INSERT INTO ttt VALUES ('01:23:45' ) "); $stm = $db->query("SELECT * FROM ttt"); foreach ( $stm as $row ) var_dump( $row ); Expected result: ---------------- array(2) { ["COL1"]=> string(8) "12:34:56" [0]=> string(8) "12:34:56" } Actual result: -------------- array(2) { ["COL1"]=> string(8) " 12:34:5" [0]=> string(8) " 12:34:5" }