Date Functions: Next_Day

Description: Gives you the date of next specified date following a given date.

NEXT_DAY(<date>, <day OF the week>)
 
Options are SUN, MON, TUE, WED, THU, FRI, AND SAT
SELECT NEXT_DAY(SYSDATE, 'SAT') FROM dual;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.