Multiple choice technology databases

You are using SQL operations in Oracle. All of the following DATE functions return a DATE datatype except one. Which one is it?

  1. NEW_TIME

  2. LAST_DAY

  3. ADD_MONTHS

  4. MONTHS_BETWEEN
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The MONTHS_BETWEEN function calculates the number of months between two dates, returning a numeric value rather than a DATE datatype. Functions like NEW_TIME, LAST_DAY, and ADD_MONTHS all perform date calculations and return a DATE datatype, making the numeric function the correct exception.

Keep practicing — related questions