Description of trunc_date.eps follows


  • 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.

"New Year" FROM DUAL;

Leave a Comment

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

Scroll to Top