Q1075
What is the default format for "Date" data type?
A.
YYYY-MM-DD
AnswerB.
MM-YYYY-DD
C.
DD-MM-YYYY
D.
None of the mentioned
Answer: Option A
Solution
Answer: Option A
Solution:
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.