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')
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')