
Date functions ADD_MONTHS(dt, i) Returns the date dt plus i months. If i is a decimal number. Oracle will automatically convert it to an integer by truncating the decimal portion (it may also be negative). EX- ADD_MONTHS(SYSDATE, 2) = ’01-SEP-2003 12:00:03′ CURRENT_DATE Returns the current date in the Gregorian calendar for the session’s …
Continue reading SQL – SinglerowFunctions in Oracle (part 1, Date Functions)