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: MONTH() Function Explained.
The SQL MONTH() function retrieves the month from a date and outputs it as an integer from 1 to 12.
Step 2: Applying to the Date.
For the date “2010-03-05”: - Year: 2010
- Month: 03
- Day: 05

Step 3: Month Extraction.
Applying MONTH() to "2010-03-05" yields 3.
Step 4: Eliminating Incorrect Options.
- Option 2 (5): Represents the day, not the month.
- Option 3 (MARCH): Is text, whereas MONTH() returns a number.
- Option 4 (MAY): Corresponds to the 5th month, which is incorrect for this date.

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