Category Archives: db

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 →