phpdatetimefloor

Round minute down to nearest quarter hour


I need to round times down to the nearest quarter hour in PHP. The times are being pulled from a MySQL database from a datetime column and formatted like 2010-03-18 10:50:00.

Example:

I'm assuming floor() is involved but not sure how to go about it.

Thanks


Solution

  • Your full function would be something like this...

    function roundToQuarterHour($timestring) {
        $minutes = date('i', strtotime($timestring));
        return $minutes - ($minutes % 15);
    }