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
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)
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
thanks for the reply...that works great!
Click Here to Expand Forum to Full Width