rounding date

would anybody know of an easy way to round the time in a date to the nearest quarter hour? i.e. 1:14 would be 1:15

thanks,
tron

I don't think it is possible without playing with a couple of various functions. One of the possible sollutions would be:

SELECT TRUNC(sysdate,'HH24') + (ROUND(TO_NUMBER(TO_CHAR(sysdate, 'MI'))/15)*15)/(24*60)
FROM dual;

thanks for the reply...that works great!