trunc in oracle code example

Example 1: truncate oracle

TRUNCATE TABLE tablename

Example 2: trunc sql

SELECT TRUNC(TO_DATE('27-OCT-92','DD-MON-YY'), 'YEAR')
  "New Year" FROM DUAL;
 
New Year
---------
01-JAN-92