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

MySQL Functions — Question 14

Back to all questions
14
Question

Question 14

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.