NEXT_DAY

=NEXT_DAY=

Syntax:
(date,day_of_week) '12-OCT-01','Monday' will return the next Mon after 12 Oct

Description:
 This function shows the day after the date specified.

FROM employees
===|| NEXT_DAY || NEXT_DAY(HIRE_DATE,'MONDAY') || || 17-JUN-87 || 22-JUN87 || || 21-SEP-89 || 25-SEP-89 || || 13-JAN-93 || 18-JAN-93 || || 17-SEP-87 || 21-SEP-87 || || 07-JUN-94 || 13-JUN-94 || || 07-JUN-94 || 13-JUN-94 || || 29-JAN-00 || 31-JAN-00 || || 24-MAR-98 || 30-MAR-98 || || 24-MAY-99 || 31-MAY-99 || || 11-MAY-96 || 13-MAY-96 || ===

FROM f_staffs
===|| BIRTHDATE || NEXT_DATE(BIRTHDATE,'THURSDAY') || || 01-JUL-80 || 03-JU-80 || || 19-MAR-79 || 22-MAR-79 || || 30-MAR-69 || 03-APR-69 || ===