TRUNC(date_in,'YYYY') : TRUNC « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. TRUNC
SQL>
SQL> DECLARE
  2     date_in DATE := TO_DATE('24-Feb-2002 05:36:00 PM','DD-MON-YYYY HH:MI:SS AM');
  3     trunc_to_year DATE;
  4     trunc_to_month DATE;
  5
  6  BEGIN
  7     trunc_to_year := TRUNC(date_in,'YYYY');
  8
  9     DBMS_OUTPUT.PUT_LINE(TO_CHAR(trunc_to_year, 'DD-MON-YYYY HH:MI:SS AM'));
 10  END;
 11  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>








13.24.TRUNC
13.24.1.TRUNC() parameter list
13.24.2.TRUNC(x[, unit]) truncates x.
13.24.3.How Oracle Interprets Two-Digit Years
13.24.4.Truncates May 25, 2005, to the first day in the month
13.24.5.Truncates 7:45:26 P.M. on May 25, 2005 to the hour
13.24.6.Examples of the TRUNC function being applied to datetime values
13.24.7.TRUNC(date_in,'YYYY')
13.24.8.TRUNC(date_in,'MM')
13.24.9.TRUNC(): truncate May 25, 2005, to the first day in the year
13.24.10.Use TRUNC(date_variable) when you want to extract a date from a timestamp