How Oracle Interprets Two-Digit Years : TRUNC « Date Timestamp Functions « Oracle PL/SQL Tutorial






The Oracle database stores all four digits of the year.

Oracle interprets the century depending on whether the YY or RR format is being used for two-digit year.

TRUNC(): truncate May 25, 2005, to the first day in the year

SQL> 
SQL>
SQL> SELECT TRUNC(TO_DATE('25-MAY-2005'), 'YYYY') 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