php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: kubecekm at crs-net dot cz
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Mon May 12 04:01:29 2025 UTC