php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #64347 Date object
Submitted: 2013-03-04 11:14 UTC Modified: 2013-12-05 17:21 UTC
Votes:4
Avg. Score:4.5 ± 0.5
Reproduced:3 of 3 (100.0%)
Same Version:1 (33.3%)
Same OS:0 (0.0%)
From: alessio at alias2k dot com Assigned: derick
Status: Assigned Package: *General Issues
PHP Version: Irrelevant OS: Debian 6
Private report: No CVE-ID:
Have you experienced this issue?
Rate the importance of this bug to you:

 [2013-03-04 11:14 UTC] alessio at alias2k dot com
Description:
------------
---
From manual page: http://www.php.net/datetime.sub#refsect1-datetime.sub-
description
---

When you have a datetime object you can modify the date adding or subtracting 
month. If you do that, the result is always unpredictable, because the mktime, 
the sub, or the modify function, always subtract the amount of days of the 
previous month. I'll make an example:
If I do
<?php
$date = new DateTime('2001-03-31');
$interval = new DateInterval('P1M');

$date->sub($interval);
echo $date->format('Y-m-d');
?>
I obtain 2001-03-03 as result, but I've expected to have 2001-02-28, because the 
previous month is february, not 28 days first.
We have the same problem if we add some months to our starting date:

<?php
$date = new DateTime('2001-03-31');
$interval = new DateInterval('P1M');

$date->add($interval);
echo $date->format('Y-m-d');
?>
I obtain 2001-05-01 as result, but also in this case I've aspected a different 
result, i think the right value is 2001-04-30, because you have to add the days 
of the next month to obtain the right result, not the days of current month.
.
The problem is also the communication with mySql, because mySql calculate the 
right result, so the comparison between two date it's impossible

Test script:
---------------
<?php
$date = new DateTime('2001-03-31');
$interval = new DateInterval('P1M');

$date->sub($interval);
echo $date->format('Y-m-d');
?>

Expected result:
----------------
2001-02-28

Actual result:
--------------
2001-03-03

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2013-12-05 17:21 UTC] mike@php.net
-Assigned To: +Assigned To: derick
 
PHP Copyright © 2001-2014 The PHP Group
All rights reserved.
Last updated: Wed Apr 23 14:02:33 2014 UTC