Calculate number of days remaining

Question

I would like to calculate the number of days remaining before a date. In my database I have a timestamp corresponding to the end date. For example Friday 30. I would like to say something like that :

7 days remaining... 6, 5, 4, etc

Can you help me please ?

What's wrong with floor(($endTimestamp - time()) / 86400); ? — Jonnix, Sep 23 '11 at 15:59
Storing timestamps in a database is not good practice. Your DBMS will provide data types which better suits dates. — str, Sep 23 '11 at 16:11

Mob · Accepted Answer · 2011-09-23T16:21:29.830

17

$future = strtotime('21 July 2012'); //Future date.
$timefromdb = //source time
$timeleft = $future-$timefromdb;
$daysleft = round((($timeleft/24)/60)/60); 
echo $daysleft;

edited Sep 23 '11 at 16:21

answered Sep 23 '11 at 15:58

Mob

10,739
6
39
57

Edited. Future should be the date you are **counting down to** – Mob Sep 23 '11 at 16:22
This doesn't go into negatives. – Grasper Dec 21 '17 at 14:30

score 9 · Answer 2 · answered Dec 08 '15 at 08:00

9

  $date1 = new DateTime("2016-01-01");  //current date or any date
  $date2 = new DateTime("2016-12-31");   //Future date
  $diff = $date2->diff($date1)->format("%a");  //find difference
  $days = intval($diff);   //rounding days
  echo $days;
  //it return 365 days omitting current day

answered Dec 08 '15 at 08:00

Muthu Kumar

97
1
1

Best solution, choose this for Y2K38. – delato468 Sep 16 '20 at 09:16
Just a question, if the date already passed the returned value is negative? – svelandiag Oct 15 '20 at 22:40

score 6 · Answer 3 · edited Sep 23 '11 at 17:13

6

$days = round((timestamp_from_database - time()) / 86400);

edited Sep 23 '11 at 17:13

Stanislav Shabalin

18,468
3
16
18

answered Sep 23 '11 at 15:59

Mircea Soaica

2,749
1
13
25

@BobbaFett What returns a timestamp? `$days` should be number of days, I'm pretty sure of it. – Stanislav Shabalin Sep 23 '11 at 17:15
This one works the best, just use `strtotime()` for the timestamp – Grasper Dec 21 '17 at 14:48

score 5 · Answer 4 · answered Sep 23 '11 at 15:58

5

SELECT DATEDIFF(yourtimestamp, CURDATE()) AS days

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

answered Sep 23 '11 at 15:58

Marc B

348,685
41
398
480

Vitalicus · Answer 5 · 2018-08-13T12:19:13.210

-1

$date1=date_create("2013-03-15");
$date2=date_create("2013-12-12");
$diff=date_diff($date1,$date2);
echo $diff->format("%R%a days");

http://php.net/manual/ro/function.date-diff.php

edited Aug 13 '18 at 12:19

answered Aug 09 '18 at 13:48

Vitalicus

890
9
14

https://www.w3schools.com/php/showphp.asp?filename=demo_func_date_diff – Vitalicus Aug 09 '18 at 16:39
1

For reference: https://stackoverflow.com/help/how-to-answer It's also better to edit your answer as people don't always read the comments. – i alarmed alien Aug 09 '18 at 19:42
When you remove your negative feedback ? – Vitalicus Aug 27 '18 at 09:44

Calculate number of days remaining

5 Answers5

Linked

Related