[Oracle] NEXT_DAY()

오라클 NEXT_DAY()

 

NEXT_DAY()

   - arugment로 전달된 date의 다음주의 명시된 요일의 date 를 구하는 함수.

   - 다음주 화요일의 날짜를 구하는 함수 ?? 

 

NEXT_DAY(date, char)

의 형태

 

NEXT_DAY returns the date of the first weekday named by char that is later than the date date. The return type is always DATE, regardless of the data type of date. The argument char must be a day of the week in the date language of your session, either the full name or the abbreviation. The minimum number of letters required is the number of letters in the abbreviated version. Any characters immediately following the valid abbreviation are ignored. The return value has same hours, minutes, and seconds component as the argument date. 

 

SQL> SELECT NEXT_DAY(TO_DATE('2020-04-10', 'YYYY-MM-DD'), 'TUESDAY') FROM DUAL ;

   --> 2020/04/14