Comparing two dates in PHP and MYSQL

Question

I want to compare two dates and time values in PHP. One date is coming from MySQL, and second one is the current date. I want to run some code when both dates are the same. I tried the code below, but condition satisfies any time which is wrong.

$current_datetime = date('Y-m-d H:i');
$send_date = date("Y-m-d H:i", strtotime($row['send_date'])); // suppose $row['send_date']'s value is '2016-10-17 15:00'
if($current_datetime == $send_date){
    //I want to run some code here
}else{
}

What is wrong with the code? I also tried to covert both dates with strtotime() before comparing, but it gave me the same issue. The above condition satisfies any time even if both dates are different.

No, its not duplicate question, I read that question but did not get answer what I want, that is why I asked new one. — Ketan Lathiya
– Ketan Lathiya, Commented Oct 17, 2016 at 5:57
I want to compare date and time(hours and minutes). I don't want to compare seconds. — Ketan Lathiya
– Ketan Lathiya, Commented Oct 17, 2016 at 5:58
Also you compare like that: $var = $row['send_date']; if((time()-(60*60*24)) == strtotime($var)){ ... } — Neel Thakkar
– Neel Thakkar, Commented Oct 17, 2016 at 5:59

Kausha Thakkar · Accepted Answer · 2016-10-17 06:09:05Z

9

Try this :

$current_datetime = date('Y-m-d H:i');
$send_date = date("Y-m-d H:i", strtotime($row['send_date'])); // suppose $row['send_date']'s value is '2016-10-17 15:00'
if(strtotime($current_datetime) == strtotime($send_date)){
    //I want to run some code here
}else{
}

Hope it helps !!!!

answered Oct 17, 2016 at 6:09

Kausha Thakkar

13611 bronze badges

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

4 Comments

AHJeebon Over a year ago

What you have changed?. Explain properly.

Kausha Thakkar Over a year ago

@AHJeebon : i did convert the dates in to strtotime format because that's the right way to compare the date values.

Ketan Lathiya Over a year ago

@KaushaThakkar : Yes, this code runs fine for me. Thanks

Kausha Thakkar Over a year ago

@KetanLathiya Thanks !! can you please give it a green tick :)

Ruslan Osmanov · Accepted Answer · 2016-10-17 06:20:48Z

2

One way is to fetch the Unix timestamp (seconds since '1970-01-01 00:00:00' UTC) from MySQL, then operate on the numbers:

$row = get_db_row("SELECT UNIX_TIMESTAMP(send_date) AS send_date_ts
  FROM table WHERE $condition");
$hours = (int) ($row['send_date_ts'] / 3600);
$current_hours = (int) (time() / 3600);
if ($hours == $current_hours) {
  // current hour
}

Timestamps are convenient because:

there is no need to take the format into account;
operations on numbers are usually faster;
the code looks cleaner.

edited Oct 17, 2016 at 6:20

answered Oct 17, 2016 at 6:12

Ruslan Osmanov

21.8k8 gold badges52 silver badges62 bronze badges

Comments

S.I. · Accepted Answer · 2016-10-17 06:16:07Z

-1

Try this. On my server is working just great I've got something else because they aren't equal. Date which I receive from database is type datetime format 2015-04-13 09:03:49

<?php
     $current_datetime = strtotime(date('Y-m-d H:i'));
     $send_date = date("Y-m-d H:i", strtotime($row['send_date'])); // suppose $row['send_date']'s value is '2016-10-17 15:00'
     if($current_datetime == $send_date){
         //I want to run some code here
         echo 'something';
     }else{ 
         echo 'something else';
     }

Output:

echo $current_datetime . '<br/>';
2016-10-17 09:19

echo $send_date .'<br/>';    
2015-04-13 09:03

// result
something else

edited Oct 17, 2016 at 6:16

answered Oct 17, 2016 at 6:02

S.I.

3,38112 gold badges53 silver badges86 bronze badges

1 Comment

Roemer Over a year ago

You are comparing a string to an integer, can't work. strtotime(date('Y-m-d H:i')) is never equal to date("Y-m-d H:i", strtotime($row['send_date'])).

Collectives™ on Stack Overflow

Comparing two dates in PHP and MYSQL

3 Answers 3

4 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related