SQL> SELECT TO_CHAR(ROUND(TO_DATE('060299 01:00:35 AM',
2 'MMDDYY HH:MI:SS AM'),
3 'MI'), 'DD-MON-YY HH:MI:SS AM') "Rounded to nearest Minute"
4 from DUAL;
Rounded to nearest Mi
---------------------
02-JUN-99 01:01:00 AM
SQL>