TRUNC(x[, unit]) truncates x. : TRUNC « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. TRUNC

By default, x is truncated to the beginning of the day.

If you supply an optional unit string, x is truncated to that unit.

SQL> SELECT TRUNC(TO_DATE('25-MAY-2005'), 'YYYY')
  2  FROM dual;

TRUNC(TO_
---------
01-JAN-05

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