#32502 [Opn->Fbk]: time/timestamp return
| From: | sniper@php.net | Date: | Wed, 30 Mar 2005 15:13:50 +0000 |
| Subject: | #32502 [Opn->Fbk]: time/timestamp return | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-76061@lists.php.net to get a copy of this message | ||
ID: 32502
Updated by: sniper@php.net
Reported By: daviscabral at gmail dot com
-Status: Open
+Status: Feedback
Bug Type: InterBase related
Operating System: Linux (Slackware)
PHP Version: 4.3.10
New Comment:
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
Previous Comments:
------------------------------------------------------------------------
[2005-03-30 14:24:59] daviscabral at gmail dot com
Description:
------------
Yesterday, our systems was update.
PHP that was 4.3.7 went to 4.3.10.
After this, data from database returns wrong.
I believe that is a problem with extension.
My problem is exactly with the SQL instruction (the code is exctaly the
same):
SELECT MOD_ID, MOD_NOME, MOD_SIGLA, MOD_HRINIMANHA, MOD_HRFINMANHA,
MOD_HRINITARDE, MOD_HRFINTARDE, MOD_TEMPOMAX FROM MODULO WHERE MOD_ID =
9999
Return in 4.3.7
9999 | 4 | Diversos | DIV | 09:00:00 | 12:00:00 | 13:30:00 | 18:00:00 |
06:00:00
Return in 4.3.10
9999 | 4 | Diversos | DIV | 17:39:24 | 17:39:24 | 17:39:24 | 17:39:24 |
17:39:24
Reproduce code:
---------------
SELECT MOD_ID, MOD_NOME, MOD_SIGLA, MOD_HRINIMANHA, MOD_HRFINMANHA,
MOD_HRINITARDE, MOD_HRFINTARDE, MOD_TEMPOMAX FROM MODULO WHERE MOD_ID =
9999
Expected result:
----------------
Return in 4.3.7
9999 | 4 | Diversos | DIV | 09:00:00 | 12:00:00 | 13:30:00 | 18:00:00 |
06:00:00
Actual result:
--------------
Return in 4.3.10
9999 | 4 | Diversos | DIV | 17:39:24 | 17:39:24 | 17:39:24 | 17:39:24 |
17:39:24
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=32502&edit=1