How to get today record with unix time in php mysql

Question

I have stored php time() in to database table with field created. That time stored in my database successfully.

Now I am willing to write a query which gets only today record from that table.

I have done something like this but not workin strtotime("2012-12-12");

For eg: I have stored this time in table 1355209509. So I want to retrieve all records of this date from mysql.

use other datatypes e.g. dev.mysql.com/doc/refman/5.0/en/datetime.html — mychalvlcek
– mychalvlcek, Commented Dec 11, 2012 at 8:18

Devart · Accepted Answer · 2012-12-11 09:21:30Z

5

You can use this query -

SELECT * FROM <table> WHERE DATE(FROM_UNIXTIME(<unix_time_column>)) = CURDATE()

answered Dec 11, 2012 at 8:17

Devart

120k23 gold badges172 silver badges189 bronze badges

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

1 Answer 1