Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

ROUND function being applied to datetime values

SQL> SQL> DECLARE   2     date_in DATE := TO_DATE('24-Feb-2002 05:16:00 PM'   3                      ,'DD-MON-YYYY HH:MI:SS AM');   4     date_rounded DATE;   5     date_truncated DATE;   6  BEGIN   7     date_rounded := ROUND(date_in);   8     date_truncated := TRUNC(date_in);   9  10     DBMS_OUTPUT.PUT_LINE(TO_CHAR(date_rounded, 'DD-MON-YYYY HH:MI:SS AM'));  11     DBMS_OUTPUT.PUT_LINE(TO_CHAR(date_truncated,'DD-MON-YYYY HH:MI:SS AM'));  12  END;  13  / PL/SQL procedure successfully completed. SQL>