Two of the possibilities:
SELECT TRUNC(sysdate) + ROUND(((sysdate-TRUNC(sysdate))*24*60)/10)*10/(24*60)
FROM dual;
SELECT TRUNC(sysdate) + 10*ROUND(TO_NUMBER(TO_CHAR(sysdate,'SSSSS'))/60/10)/(24*60)
FROM dual;
|
Results 1 to 2 of 2
Thread: Rounding datesThreaded View
|
Click Here to Expand Forum to Full Width |