php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #5564 time shifted in results of InterBase queries
Submitted: 2000-07-13 17:13 UTC Modified: 2000-07-14 22:32 UTC
From: kubecekm at crs-net dot cz Assigned:
Status: Closed Package: Other
PHP Version: 3.0.16 OS: RH Linux 6.2
Private report: No CVE-ID: None
 [2000-07-13 17:13 UTC] kubecekm at crs-net dot cz
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

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-07-14 22:32 UTC] jah at cvs dot php dot net
Already fixed in cvs. You can fetch the latest version from
http://cvs.php.net/viewcvs.cgi/~checkout~/php3/functions/interbase.c?rev=1.32
and recompile.

Note that PHP3 doesn't fully support InterBase 6, and because work on it has mostly
been discontinued, probably never will. Consider switching to PHP4.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Wed May 01 21:01:29 2024 UTC