php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #13288 date() works incorrectly for first week of April 2001
Submitted: 2001-09-13 13:13 UTC Modified: 2001-09-13 15:19 UTC
From: SeanECoates at yahoo dot ca Assigned:
Status: Closed Package: Date/time related
PHP Version: 4.0.6 OS: Win2000
Private report: No CVE-ID: None
View Developer Edit
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: SeanECoates at yahoo dot ca
New email:
PHP Version: OS:

 

 [2001-09-13 13:13 UTC] SeanECoates at yahoo dot ca 
I hope I haven't overlooked something (again), but this just popped up, and is hurting my current application, big-time.

PHP is reporting certain timestamps as the wrong date (specifically, I've found the first week of April 2001 the be erraneous). I noticed that MySQL was converting a specific set of timestamps to dates differently than my php app. So, I tested against perl as well, and PHP is definitely doing SOMETHING weird.. 

Here are the results:

[mysql]
SELECT 986184000 AS unix_time,
       FROM_UNIXTIME(986184000) AS date_stamp,
       UNIX_TIMESTAMP('2001-04-01 23:00:00') AS unix_time
--> unix_time=98618400, date_stamp='2001-04-01 23:00:00', unix_time=98618400

[php]
sean@linux1:~$ echo '<?php $date_stamp=986184000; echo $date_stamp ." = ". date("M d, Y, H:i:s A",$date_stamp) ."\n" ?>' | php -q
986184000 = Apr 01, 2001, 23:00:00 PM

[perl]
sean@linux1:~$ perl -MPOSIX -le 'print ctime(986184000)'
Sun Apr  1 23:00:00 2001

Again, I'm really sorry to waste your collective time if this is my mistake.

S

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-09-13 13:32 UTC] SeanECoates at yahoo dot ca 
I'm dumb...
Let me get back on this.. might be a windows issue.

Sorry.

S
 [2001-09-13 13:35 UTC] SeanECoates at yahoo dot ca 
Seems to be a windows issue:


Here's my test script:
<?php $date_stamp=986184000; echo $date_stamp ." = ". date("M d, Y, H:i:s A",$date_stamp) ?>

Output:
-Windows:
986184000 = Apr 02, 2001, 00:00:00 AM
-Linux (Linux linux1 2.2.19 #1 Tue Jul 3 09:26:00 EST 2001 i686 unknown)
986184000 = Apr 01, 2001, 23:00:00 PM

Is this a Daylight Savings Time issue? Why only on windows? .. sorry for the confusion. (and the really stupid initial bug report examples (-: )

S
 [2001-09-13 13:37 UTC] hholzgra@php.net 
locale / country settings ?
 [2001-09-13 15:13 UTC] derick@php.net 
There is a bug in the windows time routines, that shows up when daylight
savings
starts on April 1.  It affects the first week of April.

http://support.microsoft.com/support/kb/articles/Q214/6/61.ASP


*sigh* Do I need to say more about windows?
 [2001-09-13 15:19 UTC] SeanECoates at yahoo dot ca 
Great. I mean, not great, but thanks for the help.

It looks like Visual Studio has been fixed to avoid this. Any idea when we can expect fresh Win32 PHP binaries? I have no compiling facilities on Win32 )-:

Thanks again!

S
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Feb 05 10:01:30 2025 UTC