NEXT_DAY

NEXT_DAY function returns the date of the first instance of the particular day of the week after the specified date.

Format: NEXT_DAY (input_date, day_of_the_week);

Note: For the examples below – the SYSDATE is: 10/30/2018 2:08:06 PM

Example1:

Result: 10/31/2018 2:08:06 PM

Example2: (takes lower case of the day)

Result: 11/5/2018 2:08:06 PM

Example3: (the function allows a little typo in the name of the day).

Result: 11/5/2018 2:08:06 PM

Example4: (if the day is not a day of the week at all – then it throws an error).

Result: Error.

 

 

 

Leave a Reply

  • (will not be published)