How to calculate days between two dates in PHP?

Question

I need to calculate days between a date I get from the database and the current date.

$upload_date = mysql_query("SELECT Date FROM Setting WHERE ID = $row[ID]");
$current_date = date("Y-m-d");

How do I do it?

$daysDelta = floor((mktime() - strtotime($database['Date']) / 86400); perhaps? — Brad Christie
– Brad Christie, Commented Mar 20, 2011 at 15:16

Nicola Cossu · Accepted Answer · 2011-03-20 15:16:25Z

3

select datediff(curdate(),'2011-03-01');

answered Mar 20, 2011 at 15:16

Nicola Cossu

56.7k15 gold badges96 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Glavić · Accepted Answer · 2014-12-15 08:22:34Z

2

If you want to do it in PHP, then use the DateTime class:

$current = new DateTime($current_date);
$db_date = new DateTime($upload_date);
$days = $current->diff($db_date)->days;

Or the oldschool way:

$days = round((strtotime($current) - strtotime($db_date)) /24 /60 /60);

edited Dec 15, 2014 at 8:22

Glavić

43.6k13 gold badges79 silver badges108 bronze badges

answered Mar 20, 2011 at 15:18

mario

146k20 gold badges243 silver badges293 bronze badges

Comments

Eduardo Cuomo · Accepted Answer · 2012-10-31 14:49:02Z

Use SELECT DATEDIFF('new_date', 'old_date');

mysql> SELECT DATEDIFF('2006-04-01','2006-04-01');
+-------------------------------------+
| DATEDIFF('2006-04-01','2006-04-01') |
+-------------------------------------+
|                                   0 |
+-------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATEDIFF('2006-04-01','2007-04-01');
+-------------------------------------+
| DATEDIFF('2006-04-01','2007-04-01') |
+-------------------------------------+
|                                -365 |
+-------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATEDIFF('2006-04-01','2005-04-01');
+-------------------------------------+
| DATEDIFF('2006-04-01','2005-04-01') |
+-------------------------------------+
|                                 365 |
+-------------------------------------+
1 row in set (0.00 sec)

DATEDIFF(expr,expr2)

DATEDIFF() returns the number of days between the start date expr and the end date expr2. expr and expr2 are date or date-and-time expressions. Only the date parts of the values are used in the calculation.

mysql> SELECT DATEDIFF('1997-12-31 23:59:59','1997-12-30');
    -> 1
mysql> SELECT DATEDIFF('1997-11-30 23:59:59','1997-12-31');
    -> -31

bensiu · Accepted Answer · 2013-11-22 13:39:33Z

1

form http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_datediff

SELECT DATEDIFF( CURDATE(), Date ) FROM ....

and I would not use Date as field name, consider to change this name

edited Nov 22, 2013 at 13:39

answered Mar 20, 2011 at 15:16

bensiu

25.7k56 gold badges81 silver badges117 bronze badges

Comments

Noam · Accepted Answer · 2011-03-20 15:16:33Z

0

You can use this format http://php.net/manual/en/function.date.php and it will do it for you

answered Mar 20, 2011 at 15:16

Noam

3,4014 gold badges39 silver badges67 bronze badges

Comments

Arif · Accepted Answer · 2013-01-30 06:50:20Z

0

you can do this in a simple way as below,

$current_date = date("Y-m-d");          // Current date
$db_date = date("Y-m-d");               // Date from your database
$diff = abs(strtotime($current_date) - strtotime($db_date));
$total_days = floor ($diff /  (60*60*24));

answered Jan 30, 2013 at 6:50

Arif

1,2116 gold badges31 silver badges60 bronze badges

Collectives™ on Stack Overflow

How to calculate days between two dates in PHP?

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related