Bug #64448 [NEW]: DATE Day of Week bug for 3-10-2013
| From: | xojins at gmail dot com | Date: | Mon, 18 Mar 2013 20:47:40 +0000 |
| Subject: | Bug #64448 [NEW]: DATE Day of Week bug for 3-10-2013 | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-177861@lists.php.net to get a copy of this message | ||
From: xojins at gmail dot com
Operating system: RedHat EL5
PHP version: 5.3.23
Package: Date/time related
Bug Type: Bug
Bug description:DATE Day of Week bug for 3-10-2013
Description:
------------
When using the DATE function and returning the day of the week (lowercase L
format) returns the wrong day of the week for 3/10/2013.
The example provided shows subtracting 86400 seconds from
strtotime('03/11/2013')
to return 1362888000 seconds. When passed to DATE, it returns Saturday.
This is
wrong and should be Sunday.
You need to add 3600 to any value to calculate 3/10/13 correctly.
Test script:
---------------
$d1 = date('l', strtotime('03/12/2013')-(60*60*24)); //date('l',
1363060800 - 86400) = date('l', 1362974400) = Monday
$d2 =date('l', strtotime('03/11/2013')-(60*60*24)); //date('l',
1362974400
- 86400) = date('l', 1362888000) = Saturday != date('m-d-y', 1362888000)
$d3 =date('l', strtotime('03/10/2013')-(60*60*24)); //date('l',
1362891600
- 86400) = date('l', 1362805200) = Saturday
echo $d1 . '<br>';
echo $d2 . '<br>';
echo $d3 . '<br>';
Expected result:
----------------
Monday
Sunday
Saturday
Actual result:
--------------
Monday
Saturday
Saturday
--
Edit bug report at https://bugs.php.net/bug.php?id=64448&edit=1
--
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=64448&r=trysnapshot54
Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=64448&r=trysnapshot53
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=64448&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=64448&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=64448&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=64448&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=64448&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=64448&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=64448&r=support
Expected behavior: https://bugs.php.net/fix.php?id=64448&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=64448&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=64448&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=64448&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=64448&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=64448&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=64448&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=64448&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=64448&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=64448&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=64448&r=mysqlcfg