|  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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: rm at duxx dot nl
New email:
PHP Version: OS:


 [2003-11-13 07:16 UTC] rm at duxx dot nl

In MYSQL this was the result of

| 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

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:


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2003-11-13 19:22 UTC]
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]
changed status (closed->bogus) 
PHP Copyright © 2001-2023 The PHP Group
All rights reserved.
Last updated: Tue Mar 21 19:03:41 2023 UTC