Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

TRUNC(x[, unit]) truncates x

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>