php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #26236 one timestamp/two times
Submitted: 2003-11-13 07:16 UTC Modified: 2003-11-21 06:44 UTC
From: rm at duxx dot nl Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.3.4 OS: Winnt4
Private report: No CVE-ID: None
 [2003-11-13 07:16 UTC] rm at duxx dot nl
Description:
------------

In MYSQL this was the result of
 SELECT CURDATE(), CURTIME(), UNIX_TIMESTAMP()

+------------+-----------+------------------+
| CURDATE()  | CURTIME() | UNIX_TIMESTAMP() |
+------------+-----------+------------------+
| 2003-11-13 | 10:38:34  |       1068716314 |
+------------+-----------+------------------+


Under PHP however the result of
 echo date("m.d.Y-h:m:s", 1068716314); // the same timestamp

I get
 11.13.2003-09:11:34


So you can see 10:38:34 and 9:11:34 for the same timestamp.

Now one hour could be explained because of a the timzone of +1, where
where did those 27 minutes go ?

(I didn't find this on version 4.1.3)

Reproduce code:
---------------
 

Expected result:
----------------
 

Actual result:
--------------
 

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-11-13 19:22 UTC] iliaa@php.net
Is the MySQL and PHP running on the same server?
 [2003-11-14 03:09 UTC] rm at duxx dot nl
Both Apache and MySQL are running on the same server.
 [2003-11-14 03:51 UTC] Leblanc at phpzipscript dot org
You mistake is here :
echo date("m.d.Y-h:m:s", 1068716314); 

should be :
echo date("m.d.Y-h:i:s", 1068716314); 

'm' is for month... not minutes (which is 'i').
 [2003-11-14 04:04 UTC] rm at duxx dot nl
Yoe're right: 11.13.2003-09:38:34; only one hour because of the handling of timezones. Thanks !
 [2003-11-21 06:44 UTC] georg@php.net
changed status (closed->bogus) 
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 11:01:30 2024 UTC