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
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: rm at duxx dot nl
New email:
PHP Version: OS:

 

 [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: Fri Dec 27 02:01:29 2024 UTC