Time as php´s time() format

[Ollifi]

Hello,

i have mysql DB and there is one time column in each row.

What query I should use to get all rows marked eg. 12th aug?

the time is marked in php time() format

[fenway]

I don't follow.

[ionutvmi]

use strtotime() to get time value of 12th aug 00:00 and get first value

then add to that value 24 hours (in seconds) and get the second value

 

select from table where time is bigger then the first value and is smaller then the second value

 

[The Little Guy]

I think your looking for this:

 

select * from table_name where date_format(from_unixtime(timestamp_col), '%m-%d') = '08-12';