Oracle: TIME_BUCKET

On environments, where time_bucket is not available, some (limited?) functionality of can be simulated with constructs like follows:

select
   date '2000-01-01' + trunc( (sysdate - date '2000-01-01')*96)/96
from
   dual;

This statement rounds a date down to the nearest quarter hour.

Other date related SQL functions