Multiple choice technology databases

Which is NOT Date function?

  1. ADD_MONTHS

  2. NEXT_DAY

  3. LAST_DAY

  4. NEXT_MONTHS
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ADD_MONTHS, NEXT_DAY, and LAST_DAY are all standard SQL date functions. NEXT_MONTHS does not exist in standard SQL date function sets. The function to add months is ADD_MONTHS, not NEXT_MONTHS. NEXT_MONTHS is the invalid/non-standard option.

Keep practicing — related questions