What are Date functions?
Functions that operate on Oracle Dates are termed as Date functions. All datefunctions return a value of date datatype except the \ function months_between returns a numeric value. Function Purpose ADD_MONTHS(d,n) returns the date ‘d’ plus n months. n must be an integer. n can be positive or negative. LAST_DAY(d) returns the date of the last day of the month containing the date ‘d’. NEXT_DAY(d,char) returns date of first day of week named after char that is later than d, char must be a valid day of lthe week. MONTHS_BETWEEN(d,e) returns no of months between dates d & e.
