compare date trimming

I have a field (nonTimeStampDate) t开发者_C百科hat has date like this

2010-03-15  

and I want to check it against another field (timeStampDate) which is

2010-03-15 15:07:45    

to see if the date matchs. But as you can see since the format is different it doesnt match even though the date is same.

Any help will be appreciated. thanks

My first thought is using date() and strtotime() to reformat them.

$date1 ="2010-03-15";
$date2 = "2010-03-15 15:07:45";

if (date('Y-m-d', strtotime($date1)) == date('Y-m-d', strtotime($date2)))
{ 
   //do something 
}

This would work and give you more flexibility in how the two dates formatted to begin with. Not the most elegant.

You might want to try this code:

if (strpos($date1, $date2) !== false)  {
  // Your code here
}

It is a bit faster than exploding the value by a space as suggested by Anax. Make sure that $date2 contains the shorter of the two dates.

If you are certain about the input string format, you need to split it and take the first part, in order to compare it with your original date:

$splits = explode(' ', $original);
$datapart = $splits[0];
if ($datepart == $nonTimeStampDate) {
    // your code here
}

What Anax says, or if these values are in MySQL tables, you can use MySQLs datetime functions (like DATE()) to compare them in MySQL.

Then, just compare the date part:

<?php

if( substr('2010-03-15 15:07:45', 0, 10) == '2010-03-15' ){
    echo 'Dates match';
}

?>

Whatever, if you need to do serious date handling, you need to use a proper format, such as a DateTime object.

$firstDate = date("Y-m-d", strtotime("2010-03-15"));
$secondDate = date("Y-m-d", strtotime("2010-03-15 15:07:45"));     

if( $firstDate == $secondDate ) {
       // true    
}