Tag Archives: sql

Oracle SQL Examples: Find Next or Previous Date

Posted on March 8, 2016 by Jianming Li

Overview * Use next_day function: next_day(date, day_string) * day_string is one of the following: SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY Find Next Sunday from Today SELECT next_day(SYSDATE,’SUNDAY’) FROM dual; Find Next Sunday from a Specific Date SELECT next_day(to_date(’05-MAR-16’),’SUNDAY’) FROM … Continue reading →

Posted in oracle | Tagged , , | Leave a comment