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-05SQL>