How to check if a datetime from mysql is the same Date as another?

**Hallowed** · February 2nd, 2012, 03:52 AM

I am trying to use this function:

these variables are stored in datetime format of mysql.
var1:2012-02-01 01:39:32
var2:2012-02-02 01:47:11

PHP Code:


if (date('Ymd', $var1) == date('Ymd', $var2)
{
//True
}

Why does this output true every time?

Any other suggestions on how to do this? Please keep in mind I'm limited to doing this in PHP on this page without using any database. And I'm looking only for the same date not a 24Hour difference, however I don't care about differences in time zones as long as both variables reflect the same timezone.

**nickyc** · February 4th, 2012, 10:03 PM

It is always true because it does not compare the time part, only the date part. You need to use different pattern that includes the time part also.
Or better you can compare the milliseconds from the two dates.

**Sean4u** · February 5th, 2012, 05:41 PM

I was going to suggest you should ask this question on a PHP forum, but then I would have to not answer it

PHP: date - Manual

... says the argument is a Unix timestamp - not a MySQL datetime. What do you get if you echo the expressions either side of the '=='?

Thread: How to check if a datetime from mysql is the same Date as another?

LinkBack

Thread Tools

Display

How to check if a datetime from mysql is the same Date as another?

Related threads:

Re: How to check if a datetime from mysql is the same Date as another?

Re: How to check if a datetime from mysql is the same Date as another?

Similar Threads

How to check for empty mysql table

Want to get the start and end date of a month from current date

same date should entered in another date field

DateTime Convertion To Binary

how to check the value