#32502 [Com]: time/timestamp return

ID: 32502 Comment by: Andres dot Lilla at ra dot ee Reported By: daviscabral at gmail dot com Status: No Feedback Bug Type: InterBase related Operating System: Linux (Slackware) PHP Version: 4.3.10 New Comment: timestamp field fails between years 1881-1901. I am using php4.3.11, firebird1.5.2 and FedoraCore3. Firebird and isql work fine and give a right result. php works fine to year 1881 and at year 1902 to today. All timestamp field values between years 1881-1901 are constantly 12/13/1901 22:45:52 with php4.1.2 all is right and OK Previous Comments: ------------------------------------------------------------------------ [2005-04-07 01:00:15] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2005-03-30 17:13:49] sniper@php.net 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. ------------------------------------------------------------------------ [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