TRUNC(date)

Description of trunc_date.eps follows

Syntax:

  • The TRUNC (date) function returns date with the time portion of the day truncated to the unit specified by the format model fmt.
  • The value returned is always of data type DATE,
  • If you omit fmt, then the default format model ‘DD‘ is used and the value returned is date truncated to the day with a time of midnight.

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

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top