Round Time

Based on the value of the i_minutes input, this PL/SQL stored function returns the i_date_and_time input rounded to the nearest hour, half hour, quarter hour, etc. With SQL*Plus test script.
Download Round Time