Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 9 of 40

Practice Paper — Question 9

Back to all questions
9
Question

Question 9

Predict the output of the following query :

SELECT LCASE(MONTHNAME('2023-03-05'));
  1. May
  2. March
  3. may
  4. march
Answer

march

Reason — The MONTHNAME() function in MySQL returns the name of the month for a given date. In this case, the date '2023-03-05' corresponds to March, so MONTHNAME('2023-03-05') will return "March". Then LCASE() function is used to convert the result to lowercase, resulting in "march" as the output.