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
 [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 May 07 08:01:27 2025 UTC