What is the default format for "Date" data type?
A. YYYY-MM-DD
B. MM-YYYY-DD
C. DD-MM-YYYY
D. None of the mentioned
Answer: Option A
Solution (By Examveda Team)
This question asks about how MySQL stores dates by default.MySQL uses a specific format for storing dates, and it's important to know this format when working with dates in your database.
Let's look at the options:
Option A: YYYY-MM-DD This format is the standard way to represent dates, with year first, then month, and then day.
Option B: MM-YYYY-DD This format is not the standard format for dates.
Option C: DD-MM-YYYY This format is not the standard format for dates.
Option D: None of the mentioned This option could be correct if the default format is different from the above options.
The correct answer is Option A: YYYY-MM-DD. MySQL uses the YYYY-MM-DD format by default for storing dates.

Join The Discussion