Bug #5564: time shifted in results of InterBase queries
| From: | kubecekm at crs-net dot cz | Date: | Thu, 13 Jul 2000 21:13:39 +0000 |
| Subject: | Bug #5564: time shifted in results of InterBase queries | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-24365@lists.php.net to get a copy of this message | ||
From: kubecekm@crs-net.cz
Operating system: RH Linux 6.2
PHP version: 3.0.16
PHP Bug Type: Other
Bug description: time shifted in results of InterBase queries
any select query from TIMESTAMP column of an InterBase table, e.g.
<?
$conn = ibase_connect("server:/path/dbase.gdb",
"user", "pass", "WIN1250");
$rslt = ibase_query($conn, "select ORD_ID,ORD_EXPIRED from ORDERS;");
if (!$rslt): include "psupp/dberr.phtml"; exit; endif;
?>
...
<table>
<?
while ($row = ibase_fetch_object($rslt))
echo
"<tr><td>".$row->ORD_ID."<td>".$row->ORD_EXPIRED."\n";
?>
</table>
...
The times displayed are always shifted by one hour with respect to
the times stored in the database (e.g. 18:24 rather than 17:24).
When I use 'select cast(ORD_EXPIRED as varchar(40)) as ORD_EXP2',
the time is correct (but I cannot use ibase_timefmt then).
The server is running RedHat Linux 6.2 (glibc 2.1.3)
PHP configured with --with-interbase --with-apache=../apache_1.3.12 --enable-track-vars
Apache 1.3.12
InterBase 6.0 beta (classic architecture)
Timezone is set to Europe/Prague