Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Rounding to the Nearest Minute

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>