Select record closest to this time yesterday

[moto51]

I have a database that inserts a record every 5 minutes, 24/7. I want to easily retrieve the closest record to the current time - 1 day. Could somebody point me into the right direction please.

 

[moto51]

Solved it, used PHP as I had to use it anyway.

 

function minutes_round ($hour, $minutes = '5', $format = "H:i")
{
    $seconds = strtotime($hour);
    $rounded = round($seconds / ($minutes * 60)) * ($minutes * 60);
    return date($format, $rounded);
}


$yesterdayDate = date("Y-m-d", mktime(0, 0, 0, date("m"),date("d")-1,date("Y")));
$time = date( 'H:i:s');

$time = minutes_round($time);