Question

Give the output of the query:  SELECT MONTH("2010-03-05"); 

• A. 3
• B. 5
• C. MARCH
• D. MAY

Hint:

Remember: MONTH() returns a numeric value (1–12), while MONTHNAME() returns the name of the month (like MARCH).

Answer 1

The Correct Option is A

Step 1: Understanding MONTH() function.
The SQL MONTH() function extracts the month part from a date value and returns it as a numeric integer (1–12).
Step 2: Apply to given date.
The date given is “2010-03-05”. Here: - Year = 2010
- Month = 03
- Day = 05

Step 3: Extracting month.
MONTH("2010-03-05") = 3.
Step 4: Eliminate wrong options.
- Option 2: 5 is the day, not the month.
- Option 3: MARCH is textual format, but MONTH() gives numeric.
- Option 4: MAY corresponds to 5th month, not correct here.

Final Answer: \[ \boxed{3} \]