#36215 [Opn->Fbk]: Fetching TIME-type data from views
| From: | sniper@php.net | Date: | Sun, 12 Feb 2006 08:31:13 +0000 |
| Subject: | #36215 [Opn->Fbk]: Fetching TIME-type data from views | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-93174@lists.php.net to get a copy of this message | ||
ID: 36215
Updated by: sniper@php.net
Reported By: k dot zhinko at grape dot ru
-Status: Open
+Status: Feedback
Bug Type: InterBase related
Operating System: Windows XP Pro SP2
PHP Version: 4.4.2
New Comment:
Please try using this CVS snapshot:
http://snaps.php.net/php5.1-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.1-win32-latest.zip
Previous Comments:
------------------------------------------------------------------------
[2006-01-30 19:36:37] k dot zhinko at grape dot ru
Description:
------------
I couldn't fetch TIME-type data from views. The query processes
correctly in IBExpert.
Reproduce code:
---------------
<?php
$q = ibase_query('SELECT d.START_TIME FROM VW_SOME_VIEW');
$a = ibase_fetch_assoc($q);
print_r($a['START_TIME']);
echo "\n";
$q = ibase_query('SELECT d.START_TIME FROM VW_SOME_TABLE');
$a = ibase_fetch_assoc($q);
print_r($a['START_TIME']);
?>
Expected result:
----------------
03:44
03:44
Actual result:
--------------
-1
03:44
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=36215&edit=1