PHP MYSQL, How to compare same date two timestamp

Question

Using PHP time() function, I have got this timestamp - 1407760251 (11-08-2014)

Also using only YY-MM-DD (date picker) I have generated this timestamp - 1407708000 (11-08-2014)

MySQL table has time() timestamp, I want to filter same day records from MYSQL table how to do it? please help me.. thank you

possible duplicate of [How to calculate the difference between two dates using PHP?](http://stackoverflow.com/questions/676824/how-to-calculate-the-difference-between-two-dates-using-php) — John Robertson, Aug 20 '14 at 06:48

score 1 · Answer 1 · answered Aug 20 '14 at 06:50

1

Use date for the PHP side:

date("d-m-Y", $millis);

and use DATE on the MySQL side to make a timestamp comparable to the date you have:

SELECT someFields
FROM MyTable
WHERE DATE(myDate) = date("d-m-Y", $millis)

answered Aug 20 '14 at 06:50

Ende Neu

1 Answers1