Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Examples of the TRUNC function being applied to datetime values

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