TRUNC Use the TRUNC function to truncate a date or timestamp to a year or month. The result is a date. Syntax INT(trunc(current_date),'MM')