mysql php - select * where date = today?

[Buddah]

Yes, all timestamps should be set as int.

I would avoid using any extra MySQL processing, though, especially since you're generating your original timestamp with PHP's time().

Something like this would suffice:

$today = strtotime('12:00:00');

$sqlQuery = "SELECT * FROM theTable WHERE the_time >= {$today}";