Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 37 of 81

MySQL Functions — Question 19

Back to all questions
19
Question

Question 19

What will be returned by the given query ?

SELECT month('2020-05-11');
  1. 5
  2. 11
  3. May
  4. November
Answer

5

Reason — The MONTH() function extracts the month component from a date passed. For the date '2020-05-11', since the month is 05, it returns 5.